Re: [INTERFACES] add/delete field utility?

From: James Olin Oden <joden(at)lee(dot)k12(dot)nc(dot)us>
To: "Cary B(dot) O'Brien" <cobrien(at)access(dot)digex(dot)net>
Cc: fmorton(at)mail(dot)base2inc(dot)com, pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] add/delete field utility?
Date: 1998-09-04 11:40:28
Message-ID: 81Sep3.063049edt.35713@gateway.lee.k12.nc.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


> > 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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message mheravi 1998-09-04 13:18:33 initdb problems
Previous Message 9sun 1998-09-04 09:08:17