Re: psql batch file question

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Matt Doughty" <matt(dot)doughty(at)geograma(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql batch file question
Date: 2007-12-11 17:01:46
Message-ID: 20071211090146.78a15ce2@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 11 Dec 2007 17:50:14 +0100
"Matt Doughty" <matt(dot)doughty(at)geograma(dot)com> wrote:

> Hi List,
>
>
>
> I'm trying to write a batch file that executes a query in PostgreSQL.
> Depending on the output of the query, the batch file does one of two
> things, jumps to a line that has a command to export a table from
> PostgreSQL, or calls another batch file, which copies some files.

Use perl, python, mono/c#, java, pl/sh ... you have a wealth of various
easy to use APIs :)

Joshua D. Drake

- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHXsJ6ATb/zqfZUUQRAoooAJ9Um39yEM803oPdz99FR9cl7p14dACfTJbN
xEsrGGiRJXANHKbEpesD8o4=
=zuI9
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jay 2007-12-11 17:01:49 WHERE (columnX IN (x,y,z)) ORDER BY columnY conflict
Previous Message Joshua D. Drake 2007-12-11 17:00:05 Re: top posting (was: Hijack!)