Re: How can I check whether a table is existing or not - Mailing list pgsql-interfaces

From Manuel Sugawara
Subject Re: How can I check whether a table is existing or not
Date
Msg-id m3n1e0tfgk.fsf@dep3.fciencias.unam.mx
Whole thread Raw
In response to How can I check whether a table is existing or not  (Hans-Jürgen Schönig <hs@cybertec.at>)
List pgsql-interfaces
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.


pgsql-interfaces by date:

Previous
From: Andrew Nosenko
Date:
Subject: Re: StarOffice 5.2 for Linux and ODBC
Next
From: Katsuyuki Tanaka
Date:
Subject: passwd