Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: Check if table exists
Date
Msg-id 41C2D354.6020007@archonet.com
Whole thread Raw
In response to Check if table exists  ("ON.KG" <skyer@on.kg>)
Responses Re: Check if table exists
List pgsql-general
Tree view 
ON.KG wrote:
> Hi ALL!
>
> I need to check before selection records from table - does this table
> exist
> How can i do that?

You could:
1. Look in the INFORMATION_SCHEMA
2. Check pg_class
3. Examine the output of "psql -E", \d to see how psql gets its information.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "ON.KG"
Date:
Subject: Check if table exists
Next
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: pl/pgsql oddity