Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 129006328DA for ; Fri, 23 Jul 2010 14:25:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 32684-06 for ; Fri, 23 Jul 2010 17:25:26 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qmta03.westchester.pa.mail.comcast.net (qmta03.westchester.pa.mail.comcast.net [76.96.62.32]) by mail.postgresql.org (Postfix) with ESMTP id BE98F62E706 for ; Fri, 23 Jul 2010 14:25:26 -0300 (ADT) Received: from omta16.westchester.pa.mail.comcast.net ([76.96.62.88]) by qmta03.westchester.pa.mail.comcast.net with comcast id lPT21e0041uE5Es53VRSaH; Fri, 23 Jul 2010 17:25:26 +0000 Received: from sz0093.wc.mail.comcast.net ([76.96.58.151]) by omta16.westchester.pa.mail.comcast.net with comcast id lVRS1e00D3FmDic3cVRSWe; Fri, 23 Jul 2010 17:25:26 +0000 Date: Fri, 23 Jul 2010 17:25:26 +0000 (UTC) From: Lou Picciano To: pgsql-admin@postgresql.org Message-ID: <1372306669.488656.1279905926666.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> In-Reply-To: <95588234.488538.1279905832858.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> Subject: Re: FTP client functions? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_488655_1105702880.1279905926665" X-Originating-IP: [76.117.184.231] X-Mailer: Zimbra 6.0.5_GA_2420.RHEL4 (ZimbraWebClient - SAF3 (Mac)/6.0.5_GA_2420.RHEL4) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201007/171 X-Sequence-Number: 35190 ------=_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.

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

OK, we'll k= eep at it! 

----- Original Message -----
From: "Scott= Marlowe" <scott.marlowe@gmail.com>
To: "Lou Picciano" <loupicc= iano@comcast.net>
Cc: pgsql-admin@postgresql.org
Sent: Friday, Jul= y 23, 2010 1:03:29 PM
Subject: Re: [ADMIN] FTP client functions?

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

Easies= t way would be to install a pl/language that has something like
curl ava= ilable to it.  Then it's just simple file access from the
language = perspective.
------=_Part_488655_1105702880.1279905926665--