On Tue, 31 Aug 2004 11:09:07 -0400, Joe Maldonado <[EMAIL PROTECTED]> wrote: >CREATE SCHEMA joe > CREATE SEQUENCE joe_seq start 1 > CREATE TABLE joe_table (int id, varchar name) >; > >and I get a syntax error for SEQUENCE.
This will work in 8.0. http://www.postgresql.org/docs/7.4/static/sql-createschema.html: schema_element An SQL statement defining an object to be created within the schema. Currently, only CREATE TABLE, CREATE VIEW, and GRANT are accepted as clauses within CREATE SCHEMA. http://developer.postgresql.org/docs/postgres/sql-createschema.html: schema_element An SQL statement defining an object to be created within the schema. Currently, only CREATE TABLE, CREATE VIEW, CREATE INDEX, CREATE SEQUENCE, CREATE TRIGGER and GRANT are accepted as clauses within CREATE SCHEMA. In the meantime "Other kinds of objects may be created in separate commands after the schema is created." Servus Manfred ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org