CREATE TABLE IF NOT EXIST

This is a multi-part message in MIME format.

------=_NextPart_000_0030_01C85F31.FD013490
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 =3D '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
------=_NextPart_000_0030_01C85F31.FD013490
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">

Re: CREATE TABLE IF NOT EXIST

This is a multi-part message in MIME format.


------_=_NextPart_001_01C85F63.7E3A50AB
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

IF NOT EXISTS(SELECT tablename FROM pg_catalogpg_tables WHERE tablename=
=3D 'mytable') ..... =0A IF NOT =
EXISTS(SELECT table_name FROM information_schematables where table_=
name =3D 'mytable') Maybe the problem you are having is a permi=
ssions problem though Are you using the same account in psql as yo=
u are in ODBC? Hope that helps, Regina ________=
________________________ From: pgsql-odbc-owner@postgresqlorg=
[mailto:pgsql-odbc-owner@postgresqlorg] On Behalf Of Mike Gagnon=
Sent: Friday, January 25, 2008 9:09 AM To: pgsql-odbc@postgresql=
org Subject: [ODBC] CREATE TABLE IF NOT EXIST Hi P=
ostgres Experts, I'm trying to create tables (if they don't exi=
st) through the ODBC driver I've tried the following: =
SELECT relname FROM pg_class WHERE relname =3D '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 ou=
t if a table exists? Many thanks, Mike --=
--------------------------------------- The substance of this message,=
including any attachments, may be=0Aconfidential, legally privileged and/o=
r exempt from disclosure=0Apursuant to Massachusetts law It is intended=
solely for the addressee If you received this in error, please=0Ac=
ontact the sender and delete the material from any computer. =0A
------_=_NextPart_001_01C85F63.7E3A50AB
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

> =3Dus-ascii"> NERATOR> =0D=
=0A