pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedadd/delete field utility?
3+ messages / 3 participants
[nested] [flat]
* add/delete field utility?
@ 1998-09-03 15:44 Frank Morton <fmorton@mail.base2inc.com>
1998-09-03 17:44 ` Re: [INTERFACES] add/delete field utility? Cary B. O'Brien <cobrien@access.digex.net>
0 siblings, 1 reply; 3+ messages in thread
From: Frank Morton @ 1998-09-03 15:44 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] add/delete field utility?
1998-09-03 15:44 add/delete field utility? Frank Morton <fmorton@mail.base2inc.com>
@ 1998-09-03 17:44 ` Cary B. O'Brien <cobrien@access.digex.net>
1998-09-04 11:40 ` Re: [INTERFACES] add/delete field utility? James Olin Oden <joden@lee.k12.nc.us>
0 siblings, 1 reply; 3+ messages in thread
From: Cary B. O'Brien @ 1998-09-03 17:44 UTC (permalink / raw)
To: fmorton@mail.base2inc.com; +Cc: 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.
Am I misunderstanding the question?
-- cary
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] add/delete field utility?
1998-09-03 15:44 add/delete field utility? Frank Morton <fmorton@mail.base2inc.com>
1998-09-03 17:44 ` Re: [INTERFACES] add/delete field utility? Cary B. O'Brien <cobrien@access.digex.net>
@ 1998-09-04 11:40 ` James Olin Oden <joden@lee.k12.nc.us>
0 siblings, 0 replies; 3+ messages in thread
From: James Olin Oden @ 1998-09-04 11:40 UTC (permalink / raw)
To: Cary B. O'Brien <cobrien@access.digex.net>; +Cc: fmorton@mail.base2inc.com; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-09-04 11:40 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-09-03 15:44 add/delete field utility? Frank Morton <fmorton@mail.base2inc.com>
1998-09-03 17:44 ` Cary B. O'Brien <cobrien@access.digex.net>
1998-09-04 11:40 ` James Olin Oden <joden@lee.k12.nc.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox