X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1FFCCD1D300 for ; Thu, 15 Apr 2004 05:22:08 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 15564-02 for ; Thu, 15 Apr 2004 05:22:07 -0300 (ADT) Received: from webmail-outgoing.us4.outblaze.com (webmail-outgoing.us4.outblaze.com [205.158.62.67]) by svr1.postgresql.org (Postfix) with ESMTP id 92315D1D085 for ; Thu, 15 Apr 2004 05:22:05 -0300 (ADT) Received: from wfilter.us4.outblaze.com (wfilter.us4.outblaze.com [205.158.62.180]) by webmail-outgoing.us4.outblaze.com (Postfix) with QMQP id 026FC18001B3 for ; Thu, 15 Apr 2004 08:22:07 +0000 (GMT) X-OB-Received: from unknown (205.158.62.131) by wfilter.us4.outblaze.com; 15 Apr 2004 08:20:44 -0000 Received: by ws5-1.us4.outblaze.com (Postfix, from userid 1001) id DB1A939834A; Thu, 15 Apr 2004 08:22:06 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline Content-Transfer-Encoding: 7bit MIME-Version: 1.0 X-Mailer: MIME-tools 5.41 (Entity 5.404) Received: from [203.87.129.229] by ws5-1.us4.outblaze.com with http for vickr1z@operamail.com; Thu, 15 Apr 2004 16:22:06 +0800 From: vickr1z@operamail.com To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Date: Thu, 15 Apr 2004 16:22:06 +0800 Subject: SQL script X-Originating-Ip: 203.87.129.229 X-Originating-Server: ws5-1.us4.outblaze.com Message-Id: <20040415082206.DB1A939834A@ws5-1.us4.outblaze.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/521 X-Sequence-Number: 59763 good day toall.. imm running postgreSQL on linux. my main goal is to create a script that will dump a data from our server too my local PC. the content of the script would be execute sql command in one shot: 1. dump data 2. update and insert some rows to selected table. how can i accommplish this task and also how can i run this script? is there any one ccan help me. any idea will appreciate very much. thanks. -- _____________________________________________________________ Web-based SMS services available at http://www.operamail.com. From your mailbox to local or overseas cell phones. Powered by Outblaze