Skip site navigation (1) Skip section navigation (2)

Re: Table creation

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: (view raw, whole thread or download thread mbox)
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

In response to

pgsql-odbc by date

Next:From: Marco CassianoDate: 2009-11-16 13:49:41
Subject: Undesired decimal truncation with psqlodbc version 08.04.0100
Previous:From: ikorotDate: 2009-11-16 05:12:21
Subject: Re: Table creation

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group