Re: Check if table exists - Mailing list pgsql-general

From Guy Rouillier
Subject Re: Check if table exists
Date
Msg-id CC1CF380F4D70844B01D45982E671B2348E4CC@mtxexch01.add0.masergy.com
Whole thread Raw
In response to Check if table exists  ("ON.KG" <skyer@on.kg>)
List pgsql-general
ON.KG wrote:
> Hi ALL!
>
> I need to check before selection records from table - does this table
> exist How can i do that?

One thing to consider: you are making a trip to the database to
determine if a table exists.  If it exists, you are then making another
trip to the database to get rows from it.  For a non-destructive
operation (i.e., select), you may be better off just doing the select,
and watching for a "table does not exist" error.

--
Guy Rouillier


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: MD5(MD5(pw)) OK?
Next
From: Tom Lane
Date:
Subject: Re: OSX 10.3.7 broke Postgresql 8.0.0b5?