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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-interfaces by date

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