Postgres Pro
Downloads
Home   >   mailing lists

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

From Jennifer Trey
Subject Create table if not exists ... how ??
Date
Msg-id AANLkTikaCWrB_Dd-s4adMisqd-YR3wMudBi3yLYLcE1V@mail.gmail.com
Whole thread Raw
Responses Re: Create table if not exists ... how ??  (Raymond O'Donnell <rod@iol.ie>)
Re: Create table if not exists ... how ??  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Create table if not exists ... how ??  (Joe Conway <mail@joeconway.com>)
Re: Create table if not exists ... how ??  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: arno
Date:
Subject: Re: index scan and functions
Next
From: Raymond O'Donnell
Date:
Subject: Re: Create table if not exists ... how ??