pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: scott.marlowe <scott.marlowe@ihs.com>
To: vickr1z@operamail.com
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] SQL script
Date: Mon, 19 Apr 2004 14:17:48 -0600 (MDT)
Message-ID: <Pine.LNX.4.33.0404191414520.17372-100000@css120.ihs.com> (raw)
In-Reply-To: <20040415082206.DB1A939834A@ws5-1.us4.outblaze.com>

On Thu, 15 Apr 2004 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.

Just FYI, this might get better response on the admin mailing list...

So, what is your local PC running?  Linux, BSD, Solaris, Windows?  If NOT 
windows, then just install a copy of postgresql on it real quick to get 
access to the pg_dump utilities et. al. and use that to remotely dump the 
data out of the server onto your local machine.

Are you updating / inserting back into the big server, or locally?  either 
way, the easiest way I've found to do it is to use a scripting language 
I'm familiar with (perl, PHP, python, tcl, etc...) and massage the data in 
whatever ways you need to and then insert it into the database with that 
scripting languages pg interface package.  Other ways of doing it would be 
to get it into a SQL dump format and use psql to insert it.




view thread (3+ messages)

Message-ID: <Pine.LNX.4.33.0404191414520.17372-100000@css120.ihs.com>
Permalink:  ../Pine.LNX.4.33.0404191414520.17372-100000@css120.ihs.com/
Also on:    postgresql.org/message-id/Pine.LNX.4.33.0404191414520.17372-100000@css120.ihs.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: scott.marlowe@ihs.com, vickr1z@operamail.com, pgsql-general@postgresql.org
  Subject: Re: [SQL] SQL script
  In-Reply-To: <Pine.LNX.4.33.0404191414520.17372-100000@css120.ihs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox