>> >>> select * from dblink(‘dbname=database2 username=db_link password=mypassword','select username, email from appuser') as t1(username text, email text);: > > I think the problem is the above- ^^^^^^^^^^^^^^^ > > username=db_link should be user=db_link > > The accepted keywords are here: > http://www.postgresql.org/docs/9.3/static/libpq-connect.html#LIBPQ-CONNSTRING Yes that’s it, thanks. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general