Re: Editor for pgsql

On Mon, Jul 22, 2002 at 04:09:21PM -0400, James Orr wrote:
> On Monday 22 July 2002 12:27 pm, Josh Berkus wrote:
>
> > Me, I use Kate, an MDI text editor from the KDE crew, and CVS for
> > version control. Thanks, KDE guys! But, after 3 years of Postgres,
> > I'm pretty fluent in PL/pgSQL. I even double-quote without thinking
> > about it.
>
> How do you use CVS on your database? I recently started doing this, and i'm
> wondering how other people handle it.
>
> Basically I create a sql folder with three sub-folders tables, views
> and functions. I have a file for each table in tables, each view in
> views and for each trigger and/or function in functions.
>
> For the actual editing? I'm a vi fan myself :). If i'm using the graphical
> vim I can even do CVS operations with a custom menu.
>
> - James

James,

That sounds very ugly, I will usually have 1-4 files per db. Either
everything goes into 1 file, drops at the front then creates. Or
2 files, 1 for ddl( create/drop table) and another for plpgsql procedures
and triggers. Sometimes I will split each of those into a create and drop
file. But that is about as complex as I want it to get.

marc