PG_FOREIGN_SERVER
PG_FOREIGN_SERVER records the foreign server definitions. A foreign server describes a source of external data, such as a remote server. Foreign servers are accessed via foreign-data wrappers.
| 
        Name  | 
      
        Type  | 
      
        Reference  | 
      
        Description  | 
     
|---|---|---|---|
| 
        OID  | 
      
        OID  | 
      
        N/A  | 
      
        Row identifier (hidden attribute; displayed only when explicitly selected)  | 
     
| 
        srvname  | 
      
        Name  | 
      
        N/A  | 
      
        Name of the foreign server  | 
     
| 
        srvowner  | 
      
        OID  | 
      
        PG_AUTHID.oid  | 
      
        Owner of the foreign server  | 
     
| 
        srvfdw  | 
      
        OID  | 
      
        OID of the foreign-data wrapper of this foreign server  | 
     |
| 
        srvtype  | 
      
        Text  | 
      
        N/A  | 
      
        Type of the server (optional)  | 
     
| 
        srvversion  | 
      
        Text  | 
      
        N/A  | 
      
        Version of the server (optional)  | 
     
| 
        srvacl  | 
      
        aclitem[]  | 
      
        N/A  | 
      
        Access permissions  | 
     
| 
        srvoptions  | 
      
        Text[]  | 
      
        N/A  | 
      
        Option used for foreign servers. It is a keyword=value string.  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.