| From: | postgresql(at)bryden(dot)co(dot)za | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | Scripting issues | 
| Date: | 2005-06-21 07:16:08 | 
| Message-ID: | 37728.127.0.0.1.1119338168.squirrel@localhost | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Hi
I come from a MSSQL background and am trying to figure out how to write
deployment scripts for PostgreSQL. Typically, if I want to drop a
function, I would write a script that first checks for it's existence and
then performs the drop.
In MSSQL it would be as easy as (this can be done in native TSQL):
IF EXISTS (...some query to system tables...)
  DROP function XXX
However, I am really strugling to understand how to do this in PostgreSQL.
It seem the standard SQL language doesn't support the IF statement.
All the development that I do needs to be deployed in a script fashion and
generally I need to check for the existence of an object before replacing
or dropping.
Any help will be much appreciated.
Thanks
Craig
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-06-21 08:04:14 | Re: Access is denied during initdb | 
| Previous Message | Tino Wildenhain | 2005-06-21 06:06:42 | Re: dealing with file size when archiving databases |