Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I check if table exists in DB? - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: How can I check if table exists in DB?
Date
Msg-id 20031118083201.H41108@megazone.bigpanda.com
Whole thread Raw
In response to Re: How can I check if table exists in DB?  (Sergey Belikov <belikov@bnl.gov>)
Responses pg_dumpall pg_restore  ("Rob Sell" <lists@facnd.com>)
List pgsql-novice
Tree view 
On Tue, 18 Nov 2003, Sergey Belikov wrote:

> Hi Bruno!
> Thank you very much for your help!!! It works very nicely!!!
> Yet as I understand pg_tables is a system table. In some book I got
> advice to not rely on a schema of system tables.
>  Is there any warranty that the field names will not be changed in
> pg_tables table for at least 5 years?

Not really, but in 7.4, you'll have access to the standard
information_schema.tables which should basically stay the same barring
changes in its definition in the SQL spec.

pgsql-novice by date:

Previous
From: Sergey Belikov
Date:
Subject: Re: How can I check if table exists in DB?
Next
From: Andrei Ivanov
Date:
Subject: ERROR: nodeRead: did not find '}'