Is there a simple way to copy a table from one database to another without
generating an intermediate dump file?
TIA!
Kynn
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.
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
---(end
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
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 and
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 table name source DB | psql -d target DB
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada
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 table name source DB | psql -d