Re: Checking for table existence

From: Hans-Juergen Schoenig <hs(at)bachata(dot)cybertec(dot)at>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Checking for table existence
Date: 2001-09-15 08:48:02
Message-ID: 3BA315C2.DBC51E25@bachata.cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Simply look it up in the system tables:

SELECT * FROM pg_class WHERE relname='mydata';

Hans

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Hans-Juergen Schoenig 2001-09-15 08:56:57 Re: How to Get Timestamp From SECONDS?
Previous Message Andre Schnabel 2001-09-15 07:47:28 Re: To query many tables.