Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Geoghegan
Subject Re: Create table if not exists ... how ??
Date
Msg-id AANLkTikzoCmDn9ztDtc9tseCudqmlih9EdlQgkZpBe04@mail.gmail.com
Whole thread Raw
In response to Re: Create table if not exists ... how ??  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view 
>
>> 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..

You can write such a query inline in 9.0, by use of DO...but you
probably just want to define a function for now
--
Regards,
Peter Geoghegan

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Create table if not exists ... how ??
Next
From: Jennifer Trey
Date:
Subject: Re: Create table if not exists ... how ??