Re: loading and unloading rows

From: Naomi Walker <nwalker(at)eldocomp(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Naomi Walker <nwalker(at)eldocomp(dot)com>
Cc: Bhuvan A <bhuvansql(at)myrealbox(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: loading and unloading rows
Date: 2002-11-03 23:41:54
Message-ID: 5.1.0.14.2.20021103164103.00a09070@imap.eldocomp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Can we add unload/load functionality to the list, please?

> > >Yes, agreed, it would be nice to have WHERE as part of COPY. In fact, I
> > >like Informix's solution, which merges data in/out with INSERT/SELECT:
> > >
> > > UNLOAD TO '/tmp/x'
> > > SELECT *
> > > FROM tab;
> > >
> > >and
> > >
> > > LOAD FROM '/tmp/x'
> > > INSERT INTO tab;

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ludwig Lim 2002-11-04 06:29:30 Logging RAISE statement to a logfile aside from syslog
Previous Message Bruce Momjian 2002-11-03 01:23:38 Re: loading and unloading rows