Skip site navigation (1) Skip section navigation (2)

psql in bash scrpts, is possible ?

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 (view raw or flat)
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

Responses

pgsql-novice by date

Next:From: Mariateresa LDate: 2010-05-31 21:02:37
Subject: Fwd: psql in bash scrpts, is possible ?
Previous:From: Jasen BettsDate: 2010-05-28 10:12:36
Subject: Re: Setting up postgresql-8.3 on Debian

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group