Home > mailing lists

Re: Checking for table existence - Mailing list pgsql-sql

From	Hans-Juergen Schoenig
Subject	Re: Checking for table existence
Date	September 17, 2001 14:31:32
Msg-id	3BA315C2.DBC51E25@bachata.cybertec.at Whole thread Raw
In response to	Checking for table existence ("Julester" <cubalibr@optonline.net>)
List	pgsql-sql

Simply look it up in the system tables:

SELECT * FROM pg_class WHERE relname='mydata';
   Hans

From: "Josh Berkus"
Date: 17 September 2001, 14:31:02
Subject: Re: I could do with some guidance

From: "Julester"
Date: 17 September 2001, 14:32:52
Subject: Checking for table existence