Re: Scripting Functions to Separate Files

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Mike Fahrenkrog <mikef(at)travelpost(dot)com>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Scripting Functions to Separate Files
Date: 2005-07-06 19:13:58
Message-ID: 1120677238.1183.193.camel@Andrea.peacock.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message felix 2005-07-06 19:34:07 Re: 7.3.2 closing connections, sometimes
Previous Message Tom Lane 2005-07-06 19:10:40 Re: 7.3.2 closing connections, sometimes