Обсуждение: add/delete field utility?

Is there a utility anywhere that can take an existing
database and add or delete fields/tables? I often
need to update databases on multiple machines
that need the same structure but have different data,
so dumping the data base, updating in a text editor
and reloading gets too tedious and the sizes of
all these are going to get too large eventually.

> Is there a utility anywhere that can take an existing
> database and add or delete fields/tables? I often
> need to update databases on multiple machines
> that need the same structure but have different data,
> so dumping the data base, updating in a text editor
> and reloading gets too tedious and the sizes of
> all these are going to get too large eventually.
>

I'm not sure I understand the question, but can't you do this with
psql?  You can add and delete tables, and add fields easily (alter table ...).

Dropping a field (column, attribute, whatever) can be done by creating
a temporary table via a select with the columns you want, dropping the
old table, and renaming the temp table to what you want.

Am I misunderstanding the question?

-- cary

> > Is there a utility anywhere that can take an existing
> > database and add or delete fields/tables? I often
> > need to update databases on multiple machines
> > that need the same structure but have different data,
> > so dumping the data base, updating in a text editor
> > and reloading gets too tedious and the sizes of
> > all these are going to get too large eventually.
> >
>
> I'm not sure I understand the question, but can't you do this with
> psql?  You can add and delete tables, and add fields easily (alter table ...).
>
> Dropping a field (column, attribute, whatever) can be done by creating
> a temporary table via a select with the columns you want, dropping the
> old table, and renaming the temp table to what you want.
>

Also, he should be able to come with some script or program in any one of the
numerous languages out there to automate the processes so that he can perfect the
process once on his test database, and then just run one command on each of the
other workstations.

...james