Re: create or replace for tables and schemas

From: "Marcelo de Moraes Serpa" <celoserpa(at)gmail(dot)com>
To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "Marcelo de Moraes Serpa" <celoserpa(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: create or replace for tables and schemas
Date: 2007-08-27 11:44:56
Message-ID: 1e5bcefd0708270444r671fc852l8bf8ba47d78a7365@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Martijn

On 8/27/07, Martijn van Oosterhout <kleptog(at)svana(dot)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(at)svana(dot)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-----
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sanjay 2007-08-27 12:21:48 EXPLAIN ANALYZE not considering primary and unique indices!
Previous Message Martijn van Oosterhout 2007-08-27 11:39:17 Re: create or replace for tables and schemas