From: Iuri Sampaio <iuri.sampaio@gmail.com>
To: pgsql-sql@postgresql.org
Subject: sql query - create replace function
Date: Wed, 19 Dec 2007 21:29:13 -0800
Message-ID: <59d6a8dc0712192129s485fb71wcb7c6323fac85258@mail.gmail.com> (raw)
Hi all,
I created a script to install postgresql. One of the steps is to run a sql
query.
the problem is that i need to run the query as postgres user, plus it needs
to be at psql shell prompt command line, i.e:
# from your shell prompt enter:
$ psql <dbname>
# From the psql prompt enter the follow plpgsql code to create the
bitfromint4 function:
$ create or replace function bitfromint4 (integer) returns bit varying as '
begin return $1::bit(32); end;' language 'plpgsql' immutable strict;
#Exit psql:
$ \q
I expected something like
su - postgres -c "pgsql dbname && create or replace function bitfromint4
(integer) returns bit varying as ' begin return $1::bit(32); end;' language
'plpgsql' immutable str\
ict;"
but i see when the script runs "pgsql dbname" the bash script looses control
of the process, and there's no way back, from pgql shell prompt when it gets
in, to continue the script
iuri
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: iuri.sampaio@gmail.com
Subject: Re: sql query - create replace function
In-Reply-To: <59d6a8dc0712192129s485fb71wcb7c6323fac85258@mail.gmail.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