Re: QUERY : RE: Four art Names - Mailing list pgsql-odbc

---

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Bazil Roshan
Sent: 07 October 2005 13:10
To: pgsql-odbc@postgresql.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