PostgreSQL pgsocket: Extension for Simple TCP/IP Socket Client

最新推荐文章于 2024-09-07 15:36:16 发布

congnaoluan7899

最新推荐文章于 2024-09-07 15:36:16 发布

阅读量145

点赞数

文章标签：数据库网络 php

PostgreSQL 插件，向外部tpc/ip socket服务发生字节流。

pgsocket is an extension for PostgreSQL server to send bytes to remote TCP/IP socket server.

For the first version only single function provided for one way data send in bytearray.

This extension is compiled in Linux against PostgreSQL version 10.

Download source code from https://github.com/AbdulYadi/pgsocket . Build in Linux as usual:

$ USE_PGXS=1 make clean  
$ USE_PGXS=1 make  
$ USE_PGXS=1 make install

On successful compilation, install this extension in PostgreSQL environment

$ create extension pgsocket;

Let us send bytes to –for example– host with IP address nnn.nnn.nnn.nnn, port 9090, send time out 30 seconds, messages 'Hello'

$ select pgsocketsend('nnn.nnn.nnn.nnn', 9090, 30, (E'\\x' || encode('Hello', 'hex'))::bytea);

Or using address host name instead of IP address

$ select pgsocketsend('thesocketserver', 9090, 30, (E'\\x' || encode('Hello', 'hex'))::bytea);

Now, sending text from a table to remote TCP/IP socket server is easy. Assuming there is a table words:

id    txt  
——————–  
1    Life is easy  
2    with PostgreSQL

just do:

$ select pgsocketsend('thesocketserver', 9090, 30, (E'\\x' || encode(t.txt, 'hex'))::bytea)  
  
  
from words t WHERE t.id = 1;

原文地址：https://github.com/digoal/blog/blob/master/201809/20180913_03.md

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23503672/viewspace-2215715/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23503672/viewspace-2215715/

关注