Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PUBLIC DATABASE LINK my_link CONNECT TO my_schema IDENTIFIED BY shema_password USING 'remote';
- SELECT * FROM some_table@my_link;
- SELECT *
- FROM dblink('host= port= dbname= user= password=',
- 'select table_schema, table_name from information_schema.tables where table_schema = ''data''') AS t1 (table_schema TEXT, table_name TEXT);
- [2F003] ERROR: password is required
- Description: Non-superuser cannot connect if the server does not request a password.
- Help: Target server's authentication method must be changed.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement