Re: Create table if not exists ... how ??

From: Joe Conway <mail(at)joeconway(dot)com>
To: Igor Neyman <ineyman(at)perceptron(dot)com>
Cc: Jennifer Trey <jennifer(dot)trey(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Create table if not exists ... how ??
Date: 2010-07-19 20:55:38
Message-ID: 4C44BBCA.2060109@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message vinicius_bra 2010-07-20 00:14:36 Insert and Retrieve unsigned char sequences using C
Previous Message Igor Neyman 2010-07-19 20:54:26 Re: Create table if not exists ... how ??