Postgres Pro
Downloads
Home   >   mailing lists

create view problem - Mailing list pgsql-general

From Chris Velevitch
Subject create view problem
Date
Msg-id b0a3bf780606020234r44c26455gc7e2f41b2c0486c@mail.gmail.com
Whole thread Raw
Responses Re: create view problem
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: review SQL command history?
Next
From: dananrg@yahoo.com
Date:
Subject: Re: Best open source tool for database design / ERDs?