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