Scripting Functions to Separate Files

Started by Mike Fahrenkrogalmost 21 years ago2 messagesgeneral
Jump to latest
#1Mike Fahrenkrog
mikef@travelpost.com

Hi,
Does anyone know an efficient way to script database objects (preferably all
objects, but particularly functions) to separate files? I would like to have
a separate file for each object, so that I can easily add them to source
control.
Thanks,
--Mike

#2Tino Wildenhain
tino@wildenhain.de
In reply to: Mike Fahrenkrog (#1)
Re: Scripting Functions to Separate Files

Am Mittwoch, den 06.07.2005, 11:35 -0700 schrieb Mike Fahrenkrog:

Hi,
Does anyone know an efficient way to script database objects
(preferably all objects, but particularly functions) to separate
files? I would like to have a separate file for each object, so that I
can easily add them to source control.

Yes, you simply use a text editor and write the files.
You use psql yourdb <small_file_for_one_object
to create/modify your objects after you edit them.