Re: create or replace for tables and schemas

Поиск
Список
Период
Сортировка
От Marcelo de Moraes Serpa
Тема Re: create or replace for tables and schemas
Дата
Msg-id 1e5bcefd0708270444r671fc852l8bf8ba47d78a7365@mail.gmail.com
обсуждение исходный текст
Ответ на Re: create or replace for tables and schemas  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: create or replace for tables and schemas
Следующее
От: "Marcelo de Moraes Serpa"
Дата:
Сообщение: [ERROR] syntax error at end of input