Re: Table creation - Mailing list pgsql-odbc

From Craig Ringer
Subject Re: Table creation
Date
Msg-id 4B010020.8050405@postnewspapers.com.au
Whole thread Raw
In response to Re: Table creation  (ikorot@earthlink.net)
List pgsql-odbc
On 16/11/2009 1:12 PM, ikorot@earthlink.net wrote:
> Craig,

> So, if I call both formats, i.e.:
>
> CREATE TABLE "foo1"...;
>
> CREATE TABLE Foo2....;
>
> what will SQLTables() return?

I don't know the ODBC interface, so I can't usefully answer your
question exactly without doing some digging.

The actual tables created by PostgreSQL will be named "foo1" and "foo2"
respectively. That's what'll be shown in INFORMATION_SCHEMA and in
pg_catalog.pg_class . If SQLTables just enumerates the tables in the
database, I expect it should return "foo1" and "foo2".

--
Craig Ringer

pgsql-odbc by date:

Previous
From: ikorot@earthlink.net
Date:
Subject: Re: Table creation
Next
From: Marco Cassiano
Date:
Subject: Undesired decimal truncation with psqlodbc version 08.04.0100