On Saturday 07 Sep 2002 2:36 pm, Jean-Christian Imbeault wrote:
> I need to programmatically create a table if it does not already exists.
>
> Is there an SQL statement that will allow me to query a DB to see if a
> table exists?
select * from pg_tables
is about what you want. There are a bunch of other useful system-tables - see
the manual for details. Also you might want to start psql with -E and see
what \dt does.
- Richard Huxton