| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | Rod Taylor <pg(at)rbt(dot)ca>, Hackers <pgsql-hackers(at)postgresql(dot)org>, Gavin Sherry <swm(at)alcove(dot)com(dot)au> |
| Subject: | Re: Functions with COPY |
| Date: | 2003-11-27 15:28:07 |
| Message-ID: | 1069946887.1636.28.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)fastcrypt(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2003-11-27 16:25:32 | Re: pg_restore and create FK without verification check |
| Previous Message | Stephen Frost | 2003-11-27 15:21:06 | Re: Functions with COPY |