Postgres Pro
Downloads
Home   >   mailing lists

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

From Joe Conway
Subject Re: Create table if not exists ... how ??
Date
Msg-id 4C44BBCA.2060109@joeconway.com
Whole thread Raw
In response to Re: Create table if not exists ... how ??  ("Igor Neyman" <ineyman@perceptron.com>)
Responses Re: Create table if not exists ... how ??  (Jennifer Trey <jennifer.trey@gmail.com>)
Re: Create table if not exists ... how ??  (Jennifer Trey <jennifer.trey@gmail.com>)
List pgsql-general
Tree view 
On 07/19/2010 01:54 PM, Igor Neyman wrote:
> What you suggest is completely different from what OP asked.
>
> Jen wants to avoid getting error on CREATE TABLE in case her table
> already exists (but proceed with CREATE TABLE, if it doesn't).
> What you suggest, will drop the table (IF EXISTS), and then create it
> "anew" - what if there is already data in the table?

Read on -- we are way past that already...

Joe

--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
Attachment

pgsql-general by date:

Previous
From: "Igor Neyman"
Date:
Subject: Re: Create table if not exists ... how ??
Next
From: vinicius_bra
Date:
Subject: Insert and Retrieve unsigned char sequences using C