FTP client functions?

------=_Part_487153_1726391674.1279904316116
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

I've dont only cursory research on this so far, so thought I'd ask here first...


Does anyone know of any ftp client capabilities in Postgresql, any prebuilt functions or extensions already built?
Or is it a roll-your-own kind of thing?


Thanks, Lou
------=_Part_487153_1726391674.1279904316116
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

Re: FTP client functions?

On Fri, Jul 23, 2010 at 10:58 AM, Lou Picciano wrote:
> I've dont only cursory research on this so far, so thought I'd ask here
> first...
> Does anyone know of any ftp client capabilities in Postgresql, any prebuilt
> functions or extensions already built?
> Or is it a roll-your-own kind of thing?

Easiest way would be to install a pl/language that has something like
curl available to it. Then it's just simple file access from the
language perspective.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: FTP client functions?

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig73E1D83FF41AD4DB488F8939
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On 07/23/2010 09:58 AM, Lou Picciano wrote:
> I've dont only cursory research on this so far, so thought I'd ask here=

> first...
>=20
> Does anyone know of any ftp client capabilities in Postgresql, any
> prebuilt functions or extensions already built? =20
> Or is it a roll-your-own kind of thing?

plperl with Net::FTP?

Joe

--=20
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support


--------------enig73E1D83FF41AD4DB488F8939
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iQIcBAEBCAAGBQJMScwGAAoJEDfy90M199hlehkP/2xhqATdf3Vhx7dGivqW UudP
+VGtvvsyb/uY2q1oVco7VDBpY2ypIVEjeP/DbyRm91vvIP9nxK+bfIzqgKN4 MzvW
YI0dlelY9ORPqYZ4jrtnI8R3mgO42XzoyuhnMG62FPy8uHpAgfZd2SIS1g0W VZfA
mQNhxNEmtf0A+Ie3iNofeQ+jmvCb6haFu69En+AzasNHbRXKAo9vBeKzkml0 dh0q
bUE1q2PxK3+xEpkfLqPSz17iDwQq25xIfY/n+tMphjlz8kqTSr0/S7nN6SmI lmwu
wUCenOR5cTcL18AK3RnmZAA1hBNOA7mcYI7xhSyQetREwDSx/oMGfoMsaDnh zLtN
Tmy9wbWgjVRaIY3ErhS3J6z8OdFclgkb8kv13NBlt6FbFv91qaBFlCbTyOnj o6E0
nuu6i9LDRk33o25hdBKWBqQU+VitxSYH4rwwnLpl+12LZ+OZF8Q8EKMsWjOt G9rJ
Hj4bgMsmvNDaj6a2ukMcbfpZjSz3kNzMluxjP+hr4A9xUXeyy3ljk1Extp3L aCE6
t6mO80V3JgsZ3qUiWfRfNqIUfyIJVCUM8p4TMizwCXig0jKP46EXkuoeVySk U00a
snQCWsPT56BTqXdsWEbdQbUP85xDXLvxnJ127GJKk7ZFZUbB/IomYvpfg59i I6wL
6pISugU6MudOFEM5j4HV
=kaXg
-----END PGP SIGNATURE-----

--------------enig73E1D83FF41AD4DB488F8939--

Re: FTP client functions?

------=_Part_488655_1105702880.1279905926665
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Thanks, Scott, for that. I've already experimented a little from doing ftp calls from straight from shell - using PL/sh - of course, this is sub-optimal(!), but was good for an experiment.


Having trouble so far getting PL/php built on v9, too...


OK, we'll keep at it!

----- Original Message -----
From: "Scott Marlowe"
To: "Lou Picciano"
Cc: pgsql-admin@postgresql.org
Sent: Friday, July 23, 2010 1:03:29 PM
Subject: Re: [ADMIN] FTP client functions?

On Fri, Jul 23, 2010 at 10:58 AM, Lou Picciano wrote:
> I've dont only cursory research on this so far, so thought I'd ask here
> first...
> Does anyone know of any ftp client capabilities in Postgresql, any prebuilt
> functions or extensions already built?
> Or is it a roll-your-own kind of thing?

Easiest way would be to install a pl/language that has something like
curl available to it. Then it's just simple file access from the
language perspective.

------=_Part_488655_1105702880.1279905926665
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<=
div style=3D'font-family: Verdana; font-size: 12pt; color: #000000'>Thanks,=
Scott, for that.  I've already experimented a little from doing ftp c=
alls from straight from shell - using PL/sh - of course, this is sub-optima=
l(!), but was good for an experiment.

Re: FTP client functions?

------=_Part_488815_815026538.1279906082246
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Joe, thanks for that suggestion. I'll try it. I'd imagined any internal function would have to wrestle with encapsulating the communications - async? delays? - within a function process. Probably not too easy.


Lou

----- Original Message -----
From: "Joe Conway"
To: "Lou Picciano"
Cc: pgsql-admin@postgresql.org
Sent: Friday, July 23, 2010 1:06:14 PM
Subject: Re: [ADMIN] FTP client functions?

On 07/23/2010 09:58 AM, Lou Picciano wrote:
> I've dont only cursory research on this so far, so thought I'd ask here
> first...
>
> Does anyone know of any ftp client capabilities in Postgresql, any
> prebuilt functions or extensions already built?
> Or is it a roll-your-own kind of thing?

plperl with Net::FTP?

Joe

--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support


------=_Part_488815_815026538.1279906082246
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<=
div style=3D'font-family: Verdana; font-size: 12pt; color: #000000'>Joe, th=
anks for that suggestion. I'll try it.  I'd imagined any internal func=
tion would have to wrestle with encapsulating the communications - async? d=
elays? - within a function process.  Probably not too easy.