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" <scott.marlowe@gmail.com>
To: "Lou Picciano" <loupicciano@comcast.net>
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 <loupicciano@comcast.net> 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.