Re: QUERY : RE: Four art Names

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Bazil Roshan" <bazil_f(at)persistent(dot)co(dot)in>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: QUERY : RE: Four art Names
Date: 2005-10-07 12:37:42
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC326C@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

________________________________

From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Bazil Roshan
Sent: 07 October 2005 13:10
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] QUERY : RE: Four art Names

Please Dave can you provide more inputs on why 4 part names
cannot be supported on PGSQL.

Because a four pat name is formed from

<DatabaseName>.<CatalogName>.<SchemaName>.<TableName>

and as PostgreSQL doesn't have any concept of catalogs, your can't give
them a name (because apps that autogenerate queries might try to use
it). According to the Microsoft docs though, you can use

<DatabaseName>..<SchemaName>.<TableName>

(note the double dot). If any of their products don't like that though
you'll need to take it up with them.

Regards Dave

Browse pgsql-odbc by date

  From Date Subject
Next Message Marc Herbert 2005-10-07 13:48:40 Re: CVS Moved
Previous Message Bazil Roshan 2005-10-07 12:10:27 QUERY : RE: Four art Names