Re: loading a function from a file - Mailing list pgsql-general

From Jasen Betts
Subject Re: loading a function from a file
Date
Msg-id jl8626$r1r$1@reversiblemaps.ath.cx
Whole thread Raw
In response to loading a function from a file  (and <andreaesposito77@gmail.com>)
List pgsql-general
On 2012-03-26, and <andreaesposito77@gmail.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

pgsql-general by date:

Previous
From: Andreas
Date:
Subject: Re: Problems with Binary Replication
Next
From: Michael Nolan
Date:
Subject: Re: Problems with Binary Replication