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:
In response to
pgsql-novice by date
|Next:||From: Evans, Roy||Date: 2005-07-12 15:06:28|
|Subject: ERROR: plperl functions cannot take type anyarray|
|Previous:||From: Glenn Davy||Date: 2005-07-11 23:43:30|
|Subject: Seperate files per function...|