Re: How can I check if table exists in DB?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Sergey Belikov <belikov(at)bnl(dot)gov>
Cc: Bruno LEVEQUE <bruno(dot)leveque(at)net6d(dot)com>, NOVICE PSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How can I check if table exists in DB?
Date: 2003-11-18 16:34:23
Message-ID: 20031118083201.H41108@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Matthew Wilson 2003-11-18 20:08:56 best way to setup postgres as backend for webapp?
Previous Message Sergey Belikov 2003-11-18 16:02:09 Re: How can I check if table exists in DB?