Обсуждение: ALTER TABLE DROP CONSTRAINT IF EXISTS ?
Does PG have any way of doing $subject without writing a plpgsql-function which does it by querying the catalog manually? I'm looking for an equivalent of "DROP TABLE IF EXISTS <mytable>" -- Andreas Joseph Krogh <andreak@officenet.no> Senior Software Developer / Manager ------------------------+---------------------------------------------+ OfficeNet AS | The most difficult thing in the world is to | Karenslyst Allé 11 | know how to do a thing and to watch | PO. Box 529 Skøyen | somebody else doing it wrong, without | 0214 Oslo | comment. | NORWAY | | Tlf: +47 24 15 38 90 | | Fax: +47 24 15 38 91 | | Mobile: +47 909 56 963 | | ------------------------+---------------------------------------------+
On Jan 23, 2008 4:25 AM, Andreas Joseph Krogh <andreak@officenet.no> wrote: > Does PG have any way of doing $subject without writing a plpgsql-function > which does it by querying the catalog manually? No.