Re: [GENERAL] loading a function from a file

2012-03-31 Thread Jasen Betts
On 2012-03-26, 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? another way use

Re: [GENERAL] loading a function from a file

2012-03-26 Thread Alban Hertroys
On 26 March 2012 11:32, and wrote: > 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? If you're working on the database server, then you can skip the "-h host" bit and use a socket. That does require

Re: [GENERAL] loading a function from a file

2012-03-26 Thread Adrian Klaver
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 a

Re: [GENERAL] loading a function from a file

2012-03-26 Thread Andy Colson
On 3/26/2012 4: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? You can put default

Re: [GENERAL] loading a function from a file

2012-03-26 Thread Merlin Moncure
On Mon, Mar 26, 2012 at 4: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?

[GENERAL] loading a function from a file

2012-03-26 Thread and
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? -- Sent via pgsql-general mailing list (pgsql-general@po