Re: scripts in Postgres - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: scripts in Postgres
Date
Msg-id 1115039022.3001.37.camel@sabrina.peacock.de
Whole thread Raw
In response to Re: scripts in Postgres  ("Craig Bryden" <postgresql@bryden.co.za>)
List 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 by date:

Previous
From: Vlad
Date:
Subject: Re: 'prepare' is not quite schema-safe
Next
From: "Sean Davis"
Date:
Subject: Re: scripts in Postgres