Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How to copy tables between databases?
- From: "Uwe C. Schroeder" <uwe(at)oss4u(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Cc: "Kynn Jones" <kynnjo(at)gmail(dot)com>
- Subject: Re: How to copy tables between databases?
- Date: Tue, 26 Feb 2008 12:41:05 -0800
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 maybe have to add more switches to the pg_dump command, but the above is what I'm doing (my local db is set to trust) to copy a table with data to a remote machine Uwe -- Open Source Solutions 4U, LLC 1618 Kelly St Phone: +1 707 568 3056 Santa Rosa, CA 95401 Cell: +1 650 302 2405 United States Fax: +1 707 568 6416
- References:
- How to copy tables between databases?
- From: Kynn Jones
- How to copy tables between databases?
- Prev by Date: Re: How to copy tables between databases?
- Next by Date: Re: How to copy tables between databases?
- Previous by thread: Re: How to copy tables between databases?
- Next by thread: Re: How to copy tables between databases?
- Indexes: