Quick Links

if exists?

From:	Vincent Stoessel <vincent(at)xaymaca(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	if exists?
Date:	2002-05-13 13:33:38
Message-ID:	3CDFC0B2.7090902@xaymaca.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Is there an sql query that I can use on postgres that will tell
me if a table exists? I'm writing a perl script thatr creates a table.
But I want it to rename a table with the same name if it finds an
existing one.
Thanks
--
Vincent Stoessel
Linux Systems Developer
vincent xaymaca.com

Responses

Re: if exists? at 2002-05-13 15:25:54 from Marin Dimitrov
if exists? at 2002-05-13 15:26:14 from Lee Kindness
Re: if exists? at 2002-05-13 15:31:48 from Oliver Elphick
Re: if exists? at 2002-05-13 15:33:35 from Shaun Thomas
Re: if exists? at 2002-05-13 16:20:12 from Dave Carrigan
Re: if exists? at 2002-05-13 17:24:48 from Scott Marlowe
Re: if exists? at 2002-05-13 18:12:53 from Darko Prenosil
Re: if exists? at 2002-05-16 11:03:27 from Arindam Haldar

Browse pgsql-general by date

	From	Date	Subject
Next Message	Jan Wieck	2002-05-13 13:37:53	Re: Trigger performance
Previous Message	Jean-Michel POURE	2002-05-13 13:22:29	Re: Database encoding