Обсуждение: Seperate files per function...
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
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/