From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | 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 01:23:38 |
Message-ID: | 200211030123.gA31Ncc01206@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
We do have /contrib/dblink in 7.3 that allows cross-db query access. We
don't have any pass-data-between-db's capability that I know of.
---------------------------------------------------------------------------
Naomi Walker wrote:
> Exactly. My Informix background is showing. Is there a way to officially
> get this put on a to do list? I'd be most appreciative of the value this adds.
>
> Slightly off subject, is there a way to read from one cluster and insert
> into a database in another cluster (local or remote)? I think I read this
> is coming in the future. In Informix-land, we used to do this through a
> named pipe. It was quite handy.
>
> At 10:39 PM 11/1/02 -0500, Bruce Momjian wrote:
>
> >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;
> >
> >It is tough to beat this flexibility.
> >
> >---------------------------------------------------------------------------
> >
> >Naomi Walker wrote:
> > >
> >
> > > The problem with COPY, I think, is that I cannot use a WHERE
> > > statement. I'd like to just unload certain rows from a table. If I
> > wanted
> > > the whole table, i'll do a pg_dump or copy.
> > >
> >
> > > Again, i'd like a way to easily unload some selected rows (select * table
> > > where foo=X) from a table, and save them, or load them in another cluster,
> > > etc. Short of writing them to a temp table, then pg_dumping, or some
> > > klunk-oid mething, I do not see a clean way.
> > >
> > > Back to the maddening crowd. Anyone at least agreed this is
> > needed? Could
> > > we add "where" clauses to COPY? That would be perfect.
> > >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Naomi Walker | 2002-11-03 23:41:54 | Re: loading and unloading rows |
Previous Message | working4aliving | 2002-11-03 00:00:20 | Re: pg_hba.conf on win32 |