On Tue, Feb 26, 2008 at 2:36 PM, Brad Nicholson
<[EMAIL PROTECTED]> wrote:
> On Tue, 2008-02-26 at 15:19 -0500, Kynn Jones wrote:
> >
> > Is there a simple way to copy a table from one database to another
> > without generating an intermediate dump file?
> >
>
> pg_dump -t | psql -d
Starti
On Tue, 2008-02-26 at 15:19 -0500, Kynn Jones wrote:
>
> Is there a simple way to copy a table from one database to another
> without generating an intermediate dump file?
>
pg_dump -t | psql -d
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
On Tuesday 26 February 2008, Kynn Jones wrote:
> Is there a simple way to copy a table from one database to another without
> generating an intermediate dump file?
> TIA!
>
> Kynn
pg_dump -t [table] [database] | psql -U [remoteuser] -h [remotehost]
[remotedatabase]
comes to mind...
You can an
Kynn Jones wrote:
Is there a simple way to copy a table from one database to another without
generating an intermediate dump file?
Something along the lines of:
pg_dump ... -d db1 --table=mytable | psql -d db2
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
On Tue, Feb 26, 2008 at 9:19 PM, Kynn Jones <[EMAIL PROTECTED]> wrote:
>
> Is there a simple way to copy a table from one database to another without
> generating an intermediate dump file?
Using UNIX pipes :-)
$ pg_dump ... | psql ...
:-)
Regards,
Dawid
---(e
Kynn Jones wrote:
Is there a simple way to copy a table from one database to another
without generating an intermediate dump file?
TIA!
Kynn
You're looking for ETL.
http://en.wikipedia.org/wiki/Extract%2C_transform%2C_load
--
Tom Hart
IT Specialist
Cooperative Federal
723 Westcott St.
S
Is there a simple way to copy a table from one database to another without
generating an intermediate dump file?
TIA!
Kynn