Re: scripts in Postgres

Поиск
Список
Период
Сортировка
От Tino Wildenhain
Тема Re: scripts in Postgres
Дата
Msg-id 1115039022.3001.37.camel@sabrina.peacock.de
обсуждение исходный текст
Ответ на Re: scripts in Postgres  ("Craig Bryden" <postgresql@bryden.co.za>)
Список pgsql-general
Am Montag, den 02.05.2005, 14:05 +0200 schrieb Craig Bryden:
> Hi
>
> Thanks for the reply. Since I don't intend using any of the interfaces at
> the moment, How would I write the script below in SQL then.
> Please keep in mind that I will be sending this script to other people to
> run and that it needs to be totally automated.

How do you "run" it? if via psql, just drop the tables
unconditionally and ignore the errors.

(Or maybe you better want to drop/create the entire db)

There is no flow control in plain sql.

Regards
Tino


В списке pgsql-general по дате отправления:

Предыдущее
От: Vlad
Дата:
Сообщение: Re: 'prepare' is not quite schema-safe
Следующее
От: "Sean Davis"
Дата:
Сообщение: Re: scripts in Postgres