[ ~]$ psql -dpostgres -Upostgres -p5432
postgres=# create extension redis_fdw;
postgres=# CREATE SERVER redis_server
postgres-# FOREIGN DATA WRAPPER redis_fdw
postgres-# OPTIONS (address '127.0.0.1', port '6379');
postgres=# CREATE FOREIGN TABLE redis_db0 (key text, val text)
postgres-# SERVER redis_server
postgres-# OPTIONS (database '0');
postgres=# CREATE USER MAPPING FOR PUBLIC
postgres-# SERVER redis_server
ERROR: syntax error at or near ")"
如果是无密码就写成空,但password参数还是需要的
postgres=# CREATE USER MAPPING FOR PUBLIC postgres-# SERVER redis_server postgres-# OPTIONS (password ''); postgres=# CREATE FOREIGN TABLE myredishash (key text, val text[])
postgres-# SERVER redis_server
postgres-# OPTIONS (database '0', tabletype 'hash', tablekeyprefix 'pack_config:');
postgres=# select * from myredishash limit 10;
-------------------------------------------+---------------------------------------------------
------------------------------------------------
pack_config:2160070603:app:15158180750 | {1,"2016-06-08 15:46:23"}
pack_config:2160150608:app:18970345322 | {1,"2016-06-11 13:20:24"}
pack_config:2160150608:app:13777834990 | {1,"2016-06-16 15:09:18"}
pack_config:2160320622:app:13857143019 | {0,"2016-06-24 15:40:01"}
pack_config:2160070603:app:13575478184 | {1,"2016-06-04 19:23:06"}
pack_config:2160050527:app:13023698286 | {1,"2016-06-02 07:41:49"}
pack_config:2160150608:app:15382332310 | {4,"2016-06-09 08:15:12"}
pack_config:2160220616:wechat:13867456883 | {1,"2016-06-24 13:14:13",2,"2016-06-24 13:14:19",4
pack_config:2160150608:app:13588335935 | {2,"2016-06-11 15:32:51",1,"2016-06-11 15:33:33"}
pack_config:2160150608:app:18755998181 | {1,"2016-06-16 09:53:42",2,"2016-06-16 09:53:45",3
,"2016-06-16 09:53:46",4,"2016-06-16 09:53:48"}
postgres=# select * from myredishash where key like '%15158180750%';
----------------------------------------+---------------------------
pack_config:2160070603:app:15158180750 | {1,"2016-06-08 15:46:23"}