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

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: Hans-Jrgen Schnig <hs(at)cybertec(dot)at>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: How can I check whether a table is existing or not
Date: 2000-12-13 17:10:19
Message-ID: m3n1e0tfgk.fsf@dep3.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hans-Jrgen Schnig <hs(at)cybertec(dot)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.

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Clark, Joel 2000-12-13 20:19:53 RE: Connection Pooling...(Repost)...please do help.. .
Previous Message Katsuyuki Tanaka 2000-12-13 17:05:30 passwd