pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
FTP client functions?
5+ messages / 3 participants
[nested] [flat]

* FTP client functions?
@ 2010-07-23 16:58 Lou Picciano <loupicciano@comcast.net>
  2010-07-23 17:03 ` Re: FTP client functions? Scott Marlowe <scott.marlowe@gmail.com>
  2010-07-23 17:06 ` Re: FTP client functions? Joe Conway <mail@joeconway.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Lou Picciano @ 2010-07-23 16:58 UTC (permalink / raw)
  To: pgsql-admin

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 

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: FTP client functions?
  2010-07-23 16:58 FTP client functions? Lou Picciano <loupicciano@comcast.net>
@ 2010-07-23 17:03 ` Scott Marlowe <scott.marlowe@gmail.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Scott Marlowe @ 2010-07-23 17:03 UTC (permalink / raw)
  To: Lou Picciano <loupicciano@comcast.net>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: FTP client functions?
  2010-07-23 16:58 FTP client functions? Lou Picciano <loupicciano@comcast.net>
@ 2010-07-23 17:06 ` Joe Conway <mail@joeconway.com>
  2010-07-23 17:28   ` Re: FTP client functions? Lou Picciano <loupicciano@comcast.net>
  1 sibling, 1 reply; 5+ messages in thread

From: Joe Conway @ 2010-07-23 17:06 UTC (permalink / raw)
  To: Lou Picciano <loupicciano@comcast.net>; +Cc: pgsql-admin

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

Attachments:

  signature.asc (application/pgp-signature, 898B) download

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: FTP client functions?
  2010-07-23 16:58 FTP client functions? Lou Picciano <loupicciano@comcast.net>
  2010-07-23 17:06 ` Re: FTP client functions? Joe Conway <mail@joeconway.com>
@ 2010-07-23 17:28   ` Lou Picciano <loupicciano@comcast.net>
  0 siblings, 0 replies; 5+ messages in thread

From: Lou Picciano @ 2010-07-23 17:28 UTC (permalink / raw)
  To: pgsql-admin

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" <mail@joeconway.com> 
To: "Lou Picciano" <loupicciano@comcast.net> 
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 

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: FTP client functions?
@ 2010-07-23 17:25 Lou Picciano <loupicciano@comcast.net>
  0 siblings, 0 replies; 5+ messages in thread

From: Lou Picciano @ 2010-07-23 17:25 UTC (permalink / raw)
  To: pgsql-admin

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. 

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2010-07-23 17:28 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-07-23 16:58 FTP client functions? Lou Picciano <loupicciano@comcast.net>
2010-07-23 17:03 ` Scott Marlowe <scott.marlowe@gmail.com>
2010-07-23 17:06 ` Joe Conway <mail@joeconway.com>
2010-07-23 17:28   ` Lou Picciano <loupicciano@comcast.net>
2010-07-23 17:25 Re: FTP client functions? Lou Picciano <loupicciano@comcast.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox