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