I'm using pg 7.4.5 (cygwin) on win xp sp1. When I enter:- create view v1 as select * from t1; I get:- ERROR: syntax error at or near "view" at character 16 Why? Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au