Re: Table creation

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