From: | Mariateresa L <mariateresa(dot)ll(at)bresciaonline(dot)it> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | psql in bash scrpts, is possible ? |
Date: | 2010-05-31 20:52:56 |
Message-ID: | 4C0421A8.2090801@bresciaonline.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello everyone,
I'm building a small newspaper informations aggregator around postgresql
8.3 and Ubuntu 9.10.
Starting from a previous experience on Oracle DB, I've built and tested
a bunch of functions, triggers, SQL scripts etc... that work flawlessly
(almost !) when I submit them by hand in psql; now I want to pack
everything in a nice shell script, with proper error control, automated
file shuffling, predefined queries in text files and so on, but I
cannot convince psql that the SQL commands (select, insert or copy...)
it has to handle come from a file.
I can submit ("\i filename" or "psql --file filename") files that
contains commands, eg starting with "\" but psql does not understand the
same sintax if tne file contains a simple "SELECT * FROM tablex".
Am I uber-newbie or is this a known limitation of psql ? And, in this
case, there is something to overcome this limit and afford my non-techie
user to launch a simple command to print her data or to bulk update tables ?
P.S. Initially I discarded the use of procedural languages (C or ...)
for a quick and simpler solution !
Thanks in advance
Fabio, from North Italy
From | Date | Subject | |
---|---|---|---|
Next Message | Mariateresa L | 2010-05-31 21:02:37 | Fwd: psql in bash scrpts, is possible ? |
Previous Message | Jasen Betts | 2010-05-28 10:12:36 | Re: Setting up postgresql-8.3 on Debian |