Re: SQL: how to find if a table exists? - Mailing list pgsql-general

From Mario Weilguni
Subject Re: SQL: how to find if a table exists?
Date
Msg-id 005701c25810$29e0e200$6f01c00a@icomedias.com
Whole thread Raw
In response to SQL: how to find if a table exists?  (Jean-Christian Imbeault <totsubo2001@netscape.net>)
List pgsql-general
> Is there an SQL statement that will allow me to query a DB to see if a
> table exists?

yes, try:
select 1 from pg_class where relkind='r' and
relname='the-name-of-your-table';



pgsql-general by date:

Previous
From: Joe Murphy
Date:
Subject: Re: Vacuum and indexes problem
Next
From: Jan Ploski
Date:
Subject: Re: this is postgresql question..how do i drop unique constraint on a column?