PG_FOREIGN_DATA_WRAPPER
PG_FOREIGN_DATA_WRAPPER records foreign-data wrapper definitions. A foreign-data wrapper is the mechanism by which external data, residing on foreign servers, is accessed.
| 
        Name  | 
      
        Type  | 
      
        Reference  | 
      
        Description  | 
     
|---|---|---|---|
| 
        OID  | 
      
        OID  | 
      
        N/A  | 
      
        Row identifier (hidden attribute; displayed only when explicitly selected)  | 
     
| 
        fdwname  | 
      
        Name  | 
      
        N/A  | 
      
        Name of the foreign-data wrapper  | 
     
| 
        fdwowner  | 
      
        OID  | 
      
        PG_AUTHID.oid  | 
      
        Owner of the foreign-data wrapper  | 
     
| 
        fdwhandler  | 
      
        OID  | 
      
        PG_PROC.oid  | 
      
        References a handler function that is responsible for supplying execution routines for the foreign-data wrapper. Its value is 0 if no handler is provided.  | 
     
| 
        fdwvalidator  | 
      
        OID  | 
      
        PG_PROC.oid  | 
      
        References a validator function that is responsible for checking the validity of the options given to the foreign-data wrapper, as well as options for foreign servers and user mappings using the foreign-data wrapper. Its value is 0 if no validator is provided.  | 
     
| 
        fdwacl  | 
      
        aclitem[]  | 
      
        N/A  | 
      
        Access permissions  | 
     
| 
        fdwoptions  | 
      
        Text[]  | 
      
        N/A  | 
      
        Option used for foreign data wrappers. 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.