Thread: How can I check whether a table is existing or not

How can I check whether a table is existing or not

From
Hans-Jürgen Schönig
Date:
I am using Perl/DBI and I want to know whether I can check if a certain
table is in the database or not.
How can I do that without getting "ugly" messages on STDERR?
   Hans



Re: How can I check whether a table is existing or not

From
Manuel Sugawara
Date:
Hans-J�rgen Sch�nig <hs@cybertec.at> writes:

> I am using Perl/DBI and I want to know whether I can check if a certain
> table is in the database or not.
> How can I do that without getting "ugly" messages on STDERR?

You can query the system catalogs for the relation you are interested
in; The following query might help:

SELECT c.relname FROM pg_class c WHERE c.relname = 'my_table';

where my_table is the name of the table you are looking for.

Regards,
Manuel.