On 2012-03-26, and <andreaesposito77(at)gmail(dot)com> 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?
another way use a connection string:
psql "host=name dbname=database password=SECRET" < create_some_func.sql
another is log into psql and issue the \i psql command to read the file
\i create_some_func.sql
--
⚂⚃ 100% natural