Under the PG, under the same instance, how like SQL SERVER by adding " library prefix "can across the library to access the table of the library, example:
Select * from the library. Dbo. Table name

Thank you very much!

CodePudding user response:

Can't, postgresql link can only be a database, but postgresql schema concept, equivalent to a logical database, multiple schema can be established in a database
Can also be accessed through FDW interface (similar to dblink).