Thread: Seperate files per function...

Seperate files per function...

From
Glenn Davy
Date:
Hi all
I like to keep my views and functions etc in seperate files for source
control purposes. What I'd like to do is have a 'master' script that
includes each of the other files, in correct sequence.
i.e. psql < masterscript.sql
which would call each of fx_a.sql, fx_b.sql etc etc

The questing is whats the syntax in the master script to include
fx_a.sql,fx_b.sql etc?

Thanks
glenn




Re: Seperate files per function...

From
Michael Fuhr
Date:
On Tue, Jul 12, 2005 at 09:43:30AM +1000, Glenn Davy wrote:
> I like to keep my views and functions etc in seperate files for source
> control purposes. What I'd like to do is have a 'master' script that
> includes each of the other files, in correct sequence.
> i.e. psql < masterscript.sql
> which would call each of fx_a.sql, fx_b.sql etc etc
>
> The questing is whats the syntax in the master script to include
> fx_a.sql,fx_b.sql etc?

"\i filename" should work.  See "Meta-Commands" in the psql documentation:

http://www.postgresql.org/docs/8.0/static/app-psql.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/