Re: Functions with COPY - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: Functions with COPY
Date
Msg-id 1069946887.1636.28.camel@localhost.localdomain
Whole thread Raw
In response to Re: Functions with COPY  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Stephen,

You can do whatever you can do with an insert now, so yes, I think that
is possible. Even if the current patch doesn't do that, it would
certainly be a start.

Dave


On Thu, 2003-11-27 at 10:21, Stephen Frost wrote:
> * Dave Cramer (pg@fastcrypt.com) wrote:
> > There is a patch floating around for informix load/unload
> > 
> > the syntax is load from 'file' insert into ...., and unload to 'file'
> > select "whatever you like"
> > 
> > Would this solve the problem?
> 
> I'm not sure.  It depends on what you can do with the '....' after
> 'insert into'.  If it's :
> insert into blah (what here?) to_number(blah1,'99V99'),etc
> 
> Then I'd think it would work, but I don't know if that's what you're
> saying or not.
> 
>     Stephen



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Functions with COPY
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_restore and create FK without verification check