Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Table or not table ?

From: Ivo Simicevic <ivo(at)ultra(dot)hr>
To: Edouard DESSIOUX <edx(at)intrinsec(dot)com>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Table or not table ?
Date: 1999-12-13 17:31:43
Message-ID: 19991213183143.B1280@ultra.hr (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Mon, Dec 13, 1999 at 05:23:59PM +0100, Edouard DESSIOUX wrote:
> Hello
> 
> I wanted to be sure that a table exist before
> making a request such as "select * from $table"
> because it display something like 
> 
> Warning: PostgresSQL query failed: 
> ERROR: prout: Table does not exist. in
> /www/dooz.corp.intrinsec.com/tableau.php3 on line 15
> 
> Does anyone know what i could do to verify that
> the table exist, or help to disable error messages
> on web pages ?
> 
> Bye
> 
> -- 

Try

select * from pg_tables where tablename="wanted_table";

Ivo.

In response to

pgsql-interfaces by date

Next:From: Ed LoehrDate: 1999-12-13 18:37:30
Subject: [GENERAL/INTERFACES] Dynamically detecting need to vacuum?
Previous:From: Lamar OwenDate: 1999-12-13 17:08:55
Subject: Re: [INTERFACES] Table or not table ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group