Home > mailing lists

Create table if not exists ... how ?? - Mailing list pgsql-general

From	Jennifer Trey
Subject	Create table if not exists ... how ??
Date	July 19, 2010 16:33:49
Msg-id	AANLkTikaCWrB_Dd-s4adMisqd-YR3wMudBi3yLYLcE1V@mail.gmail.com Whole thread Raw
Responses	Re: Create table if not exists ... how ?? Re: Create table if not exists ... how ?? Re: Create table if not exists ... how ?? Re: Create table if not exists ... how ??
List	pgsql-general

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: arno
Date: 19 July 2010, 16:26:05
Subject: Re: index scan and functions

From: Raymond O'Donnell
Date: 19 July 2010, 16:39:27
Subject: Re: Create table if not exists ... how ??