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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly