DBA Hub

📋Steps in this guide1/1

Find foreign server details

postgres=# \des+ List of foreign servers Name  | Owner | Foreign-data wrapper | Access privileges | Type | Version | FDW options | Description ------+-------+----------------------+-------------------+------+---------+-------------+------------- (0 rows)

postgresql configurationintermediate
by PostgreSQL
17 views
1

Find foreign server details

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
postgres=#
\des+
List of foreign servers
Name  | Owner | Foreign-data wrapper | Access privileges | Type | Version | FDW options | Description
------+-------+----------------------+-------------------+------+---------+-------------+-------------
(0 rows)
postgres=#
select srvname,srvowner,srvoptions,fdwname,srvversion,srvtype from pg_foreign_server join pg_foreign_data_wrapper b on b.oid=srvfdw;
srvname  | srvowner | srvoptions | fdwname | srvversion | srvtype
---------+----------+------------+---------+------------+---------
(0 rows)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!