Re: loading a function from a file

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: loading a function from a file
Дата
Msg-id jl8626$r1r$1@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на loading a function from a file  (and <andreaesposito77@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Andreas
Дата:
Сообщение: Re: Problems with Binary Replication
Следующее
От: Michael Nolan
Дата:
Сообщение: Re: Problems with Binary Replication