Re: loading a funtion script from a file - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: loading a funtion script from a file
Date
Msg-id 20071121155003.GA5201@KanotixBox
Whole thread Raw
In response to loading a funtion script from a file  ("Pau Marc Munoz Torres" <paumarc@gmail.com>)
Responses Re: loading a funtion script from a file
List pgsql-general
Pau Marc Munoz Torres <paumarc@gmail.com> schrieb:

> Hi
>
>  I've written a sql function in a text file, and now, i would like to upload
> into postgresql an execute, is there any command to do it? as far as I know in
> mysql exist source command, is there something similar in postgresql?

Of course. Start psql and type:

\i /path/to/your/script.sql


Regards, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: "Sergey Konoplev"
Date:
Subject: Dynamic expressions set in "order by" clause
Next
From: Erik Jones
Date:
Subject: Re: Postgres table size