On 03/26/2012 02:32 AM, and wrote:
Hi all,
I would like to know how to load a user defined function from a file
written in pl/pgsql.
I have read it on logging
psql -h host database< create_some_func.sql
but then i am forced to redo the login.Is there another way to do it?
Not sure what you are trying to achieve? If the file/function is outside
the database and you want it inside, at some point you are going to have
to log into the database to make the transfer. If you are working in the
database using psql you can use the \i command:
test=> \i ~/some_dir/some_func_file.sql
If that is not what you are after, then we will need more detail.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
