Re: Sockets and posgtres

Jim Nasby wrote:
>
> If I'm understanding what you're trying to do (have a function connect
> to an external process?), I don't think anything exists right now. But
> it shouldn't be too hard to write something to do that. You might want
> to create a generic utility and put it on pgFoundry in case others
> find it useful. Oracle has a package that allows for TCP (as well as
> other communications) from the database; looking at their interface
> might be useful.
> --
> Jim Nasby jim(at)nasby(dot)net
> EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
You can easily do that with PLperl

The funtion then connects to the server running on localhost, and sends
some commands terminated with CRLF.

CREATE or REPLACE FUNCTION public.psendpopup(text,text)
RETURNS pg_catalog.varchar AS
$BODY$
use IO::Socket;
$sock = new IO::Socket::INET (
PeerAddr => 'localhost',
PeerPort => '32000',
Proto => 'tcp',
);
die "Could not create socket: $!\n" unless $sock;
print $sock "null\r\n";
print $sock "send_broadcast\r\n";
print $sock $_[0]."\r\n";
print $sock $_[1]."\r\n";

close($sock);
$BODY$
LANGUAGE 'plperlu' VOLATILE;

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration