From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Jennifer Trey <jennifer(dot)trey(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Create table if not exists ... how ?? |
Date: | 2010-07-19 16:40:51 |
Message-ID: | AANLkTikrqAwq63e5qAuuP9FU7ce-gWEciaepzRgYORon@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
you can use IF statement only inside plpgsql function. CREATE TABLE
doesn't support clause IF.
Regards
Pavel Stehule
2010/7/19 Jennifer Trey <jennifer(dot)trey(at)gmail(dot)com>:
> 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...
> ^
> ********** Error **********
> ERROR: syntax error at or near "IF"
> SQL state: 42601
> Character: 1
>
> How should this be written ?
> Thanks, Jen
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2010-07-19 16:42:56 | Re: Create table if not exists ... how ?? |
Previous Message | Raymond O'Donnell | 2010-07-19 16:39:12 | Re: Create table if not exists ... how ?? |