________________________________

From: pgsql-odbc-owner@postgresql.org
[mailtogsql-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>.<TableNa me>



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