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.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
