Hannu Krosing wrote: > In my brief reading of SQL-MED spec I could only find info on defining > FOREIGN SERVER and FOREIGN-DATA WRAPPER and nowhere in these could one > define connection parameters like username and password.
It is cleverly hidden. The CREATE SERVER and CREATE USER MAPPING take generic options (list of key/value pairs). These can be used for defining the actual connection to the remote server. >From http://www.wiscorp.com/sql_2003_standard.zip "4.4 User mappings": "A user mapping is an SQL-environment element, pairing an ... ... The mapping is specified by generic options defined by the foreign-data wrapper." and "13.3 <user mapping definition>": <user mapping definition> ::= CREATE USER MAPPING FOR <specific or generic authorization identifier> SERVER <foreign server name> [ <generic options> ] regards, Martin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
