Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql ddl scripts - drop object fails entire script - Mailing list pgsql-general

From A. Kretschmer
Subject Re: postgresql ddl scripts - drop object fails entire script
Date
Msg-id 20060927051349.GA27592@a-kretschmer.de
Whole thread Raw
In response to postgresql ddl scripts - drop object fails entire script  (timasmith@hotmail.com)
List pgsql-general
Tree view 
am  Sun, dem 24.09.2006, um 18:45:12 -0700 mailte timasmith@hotmail.com folgendes:
> Is there a 'drop if doesnt exist' or a better way of doing it?

8.2, read
http://developer.postgresql.org/pgdocs/postgres/release-8-2.html

DROP object IF EXISTS


HTH, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Documenting stored procedures and functions
Next
From: Jim Nasby
Date:
Subject: Re: postgresql rising