logo       
Google Custom Search
    AddThis Social Bookmark Button

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

Subject: Re: How can I check if table exists in DB?
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.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings




Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>