postgresql dblink mysql_PostgreSQL dblink使用过程

安装：

进入/root/postgresql-11.2/contrib/dblink

make && make install

切换到postgres用户

[root@fce40690-0e46-4603-e80e-ca351bda31ec dblink]# su - postgres

上一次登录：三 5月  8 03:47:54 UTC 2019pts/1 上

[postgres@fce40690-0e46-4603-e80e-ca351bda31ec ~]$ psql

psql (11.2)

Type "help" for help.

postgres=# create extension dblink;

ERROR:  extension "dblink" already exists

使用：

postgres=# select dblink_connect('mydb', 'dbname=mydb host=localhost');

dblink_connect

----------------

OK

(1 row)

postgres=# select * from dblink('mydb', 'select * from test') as test(id integer, info varchar(8));

ERROR:  value too long for type character varying(8)

postgres=# select * from dblink('mydb', 'select * from test') as test(id integer, info varchar(32));

id |               info

----+----------------------------------

1 | c53bc2b29be0ef76d863a53efed13ea1

2 | 28fd974058eb778168482942c8894004

3 | 6e90dbdf605adffe70761aa8521ab626

4 | c32edb06e0f7e0067322f346ec60e663

5 | 2eb0c9fcb931ede7440244745c686177

6 | d34a41454758897e9b9d0c2dd1a972ae

7 | 09d8e45db5f32a20e4e77ed51cf34b1a

8 | 86cb5c36edda6fffd9f9c75aa9c3f0fe

9 | 7ae28a3b304291dbcb96d19b92b42012

10 | 581fddcce1c9e66a42ae4fad8a604e0d

(10 rows)

postgres=# select dblink_get_connections();

dblink_get_connections

------------------------

{mydb}<