Postgres Pro
Downloads
Home   >   mailing lists

CREATE TABLE IF NOT EXIST - Mailing list pgsql-odbc

From Mike Gagnon
Subject CREATE TABLE IF NOT EXIST
Date
Msg-id 003301c85f5b$e891c8b0$640fa8c0@T60
Whole thread Raw
Responses Re: CREATE TABLE IF NOT EXIST
List pgsql-odbc
Tree view
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

pgsql-odbc by date:

Previous
From: Guillaume Gautreau
Date:
Subject: Re: Driver 8.1 : fails contacting the server with routable address
Next
From: Lathrop_Steve@emc.com
Date:
Subject: Building ODBC driver issue