CREATE TABLE IF NOT EXIST

["Mike Gagnon" <mike(dot)gagnon(at)bellnet(dot)ca>]

Hi Postgres Experts,

 

I'm trying to create tables (if they don't exist) through the ODBC driver.  I've tried the following:

 

SELECT relname FROM pg_class  WHERE relname = 'mytable';

 

This works from the psql command line program when logged into my database, but not when connected to my database over ODBC ( I get SQL_NO_DATA back from SQLFetch)

 

Any ideas?  Are there other ways to find out if a table exists?

 

Many thanks,

Mike