Iuri Sampaio wrote:
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:
Why does it need to be at the psql prompt?
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;"
What's wrong with this?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
