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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
