X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 258078BA021 for ; Mon, 14 Feb 2005 15:41:37 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17463-07 for ; Mon, 14 Feb 2005 15:41:33 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 2C2BD8B9C3C for ; Mon, 14 Feb 2005 15:41:32 +0000 (GMT) Received: (qmail 28640 invoked by uid 500); 14 Feb 2005 15:56:34 -0000 Date: Mon, 14 Feb 2005 09:56:34 -0600 From: Bruno Wolff III To: Chandra Mouli S Cc: pgsql-admin@postgresql.org Subject: Re: Importing and Exporting Tables. Message-ID: <20050214155634.GA28291@wolff.to> Mail-Followup-To: Chandra Mouli S , pgsql-admin@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/115 X-Sequence-Number: 16283 On Mon, Feb 14, 2005 at 13:19:11 +0530, Chandra Mouli S wrote: > Hi, > > I have POSTGRESQL v8.0 for Windows installed in my home computer. > > I work simultaneously in my home and in my office. > > I like someone to help me to find a way to: > > EXPORT the tables in my home pc to some file format > from which I can IMPORT back the same tables in my office system. You can use pg_dump/pg_dumpall to dump as text and use psql reload.