From: Richard Huxton <dev@archonet.com>
To: vickr1z@operamail.com, pgsql-general@postgresql.org,
	pgsql-sql@postgresql.org
Subject: Re: SQL script
Date: Thu, 15 Apr 2004 10:12:24 +0100
User-Agent: KMail/1.5
References: <20040415082206.DB1A939834A@ws5-1.us4.outblaze.com>
In-Reply-To: <20040415082206.DB1A939834A@ws5-1.us4.outblaze.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200404151012.24789.dev@archonet.com>

On Thursday 15 April 2004 09:22, vickr1z@operamail.com wrote:
> 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.

How are you connecting from client <=> server?
Do you just want a pg_dump style dump, a specific table/query?
Do you need to provide values for this update/insert, or is it fixed (updating 
timestamps sort of thing).

-- 
  Richard Huxton
  Archonet Ltd