Re: create or replace for tables and schemas - Mailing list pgsql-general

From Marcelo de Moraes Serpa
Subject Re: create or replace for tables and schemas
Date
Msg-id 1e5bcefd0708270444r671fc852l8bf8ba47d78a7365@mail.gmail.com
Whole thread Raw
In response to Re: create or replace for tables and schemas  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Thanks Martijn

On 8/27/07, Martijn van Oosterhout <kleptog@svana.org> wrote:
On Mon, Aug 27, 2007 at 08:24:51AM -0300, Marcelo de Moraes Serpa wrote:
> With this in mind, I'd like to know if there is something like CREATE OR
> REPLACE for tables and schemas so that if the object already exists, it will
> just replace it.

Looks lke DROP IF EXISTS was made for you.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFG0rflIB7bNG8LQkwRAsOZAJ0QyEMaNtMR0Sa1xmuzPDT58So35wCgg8qw
5r27tWKhBnYAkspu34z91Og=
=KhPb
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: create or replace for tables and schemas
Next
From: "Marcelo de Moraes Serpa"
Date:
Subject: [ERROR] syntax error at end of input