Re: Check if table exists

From: Richard Huxton <dev(at)archonet(dot)com>
To: "ON(dot)KG" <skyer(at)on(dot)kg>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Check if table exists
Date: 2004-12-17 12:38:44
Message-ID: 41C2D354.6020007@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard_D_Levine 2004-12-17 12:47:49 Re: pl/pgsql oddity
Previous Message Filip Wuytack 2004-12-17 11:10:12 Multi row sequence?