| From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
|---|---|
| To: | Craig Bryden <postgresql(at)bryden(dot)co(dot)za> |
| Cc: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>, pgsql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: scripts in Postgres |
| Date: | 2005-05-02 13:03:41 |
| Message-ID: | 1115039022.3001.37.camel@sabrina.peacock.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Davis | 2005-05-02 13:06:07 | Re: scripts in Postgres |
| Previous Message | Vlad | 2005-05-02 12:59:58 | Re: 'prepare' is not quite schema-safe |