create table as problem - Mailing list pgsql-general

From garry saddington
Subject create table as problem
Date
Msg-id 1158352955.30096.3.camel@localhost
Whole thread Raw
Responses Re: create table as problem
List pgsql-general
I am getting a syntax error at or near 'as' in this method, can anyone
help?

create table iclasses
(classid serial,
subject text,
year text,
groups text,
teacher text,
set text
)
as select distinct subject,year,groups,teacher,set from interimclasses

I need to make a new table with a classid. Any comments are more than
welcome.
regards
garry


pgsql-general by date:

Previous
From: zeljko
Date:
Subject: Re: compressed protocol
Next
From: Michael Fuhr
Date:
Subject: Re: create table as problem