Re: [SQL] sql query - create replace function

2007-12-20 Thread Richard Huxton
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 somet

[SQL] sql query - create replace function

2007-12-19 Thread Iuri Sampaio
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 # From the psql prompt enter the follow plp