On 19/07/2010 17:33, Jennifer Trey wrote:
I can't figure out the correct syntax...I have this, but it just keeps complaining about the IF IF NOT EXISTS (SELECT table_name FROM information_schema.tables where table_name = 'post_codes') THEN CREATE TABLE post_codes ( area character varying(10) NOT NULL, district character varying(10) NOT NULL, sector character varying(10) NOT NULL, CONSTRAINT post_codes_pkey PRIMARY KEY (area, district, sector) ) WITH ( OIDS=FALSE ); ALTER TABLE post_codes OWNER TO postgres; - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ERROR: syntax error at or near "IF" LINE 1: IF NOT EXISTS (SELECT table_name FROM information_schema.tab... ^
How should this be written ?
I don't think you can use the "IF" like this in a normal query. You could write a pl/pgsql function instead to do this..
Ray. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
