pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Table or not table ?
3+ messages / 3 participants
[nested] [flat]

* Table or not table ?
@ 1999-12-13 16:23 Edouard DESSIOUX <edx@intrinsec.com>
  1999-12-13 17:08 ` Re: [INTERFACES] Table or not table ? Lamar Owen <lamar.owen@wgcr.org>
  1999-12-13 17:31 ` Re: [INTERFACES] Table or not table ? Ivo Simicevic <ivo@ultra.hr>
  0 siblings, 2 replies; 3+ messages in thread

From: Edouard DESSIOUX @ 1999-12-13 16:23 UTC (permalink / raw)
  To: pgsql-interfaces

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

-- 
Edouard DESSIOUX
Proverbe chien :
"Si ca se mange pas,
 Si ca se baise pas,
 Pisse dessus !!"



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [INTERFACES] Table or not table ?
  1999-12-13 16:23 Table or not table ? Edouard DESSIOUX <edx@intrinsec.com>
@ 1999-12-13 17:08 ` Lamar Owen <lamar.owen@wgcr.org>
  1 sibling, 0 replies; 3+ messages in thread

From: Lamar Owen @ 1999-12-13 17:08 UTC (permalink / raw)
  To: Edouard DESSIOUX <edx@intrinsec.com>; +Cc: pgsql-interfaces

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

SELECT tablename FROM pg_tables WHERE tablename='$table';

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [INTERFACES] Table or not table ?
  1999-12-13 16:23 Table or not table ? Edouard DESSIOUX <edx@intrinsec.com>
@ 1999-12-13 17:31 ` Ivo Simicevic <ivo@ultra.hr>
  1 sibling, 0 replies; 3+ messages in thread

From: Ivo Simicevic @ 1999-12-13 17:31 UTC (permalink / raw)
  To: Edouard DESSIOUX <edx@intrinsec.com>; +Cc: 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.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1999-12-13 17:31 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-12-13 16:23 Table or not table ? Edouard DESSIOUX <edx@intrinsec.com>
1999-12-13 17:08 ` Lamar Owen <lamar.owen@wgcr.org>
1999-12-13 17:31 ` Ivo Simicevic <ivo@ultra.hr>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox