From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
---|---|
To: | ikorot(at)earthlink(dot)net |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Table creation |
Date: | 2009-11-16 07:32:48 |
Message-ID: | 4B010020.8050405@postnewspapers.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 16/11/2009 1:12 PM, ikorot(at)earthlink(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Marco Cassiano | 2009-11-16 13:49:41 | Undesired decimal truncation with psqlodbc version 08.04.0100 |
Previous Message | ikorot | 2009-11-16 05:12:21 | Re: Table creation |