Skip site navigation (1) Skip section navigation (2)

Re: adding a field

From: Anne Wainwright <anotheranne(at)fables(dot)co(dot)za>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: adding a field
Date: 2012-08-10 11:55:46
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Fri, Aug 10, 2012 at 10:16:27AM +0200, Thomas Kellerer wrote:
> Anne Wainwright wrote on 10.08.2012 10:04:
>> to add a field I have to take the data out, add a new field to postgres,
>> add a new (delimiter)field with any default data at the end of each
>> record, then put the data back.
>> right?
> No, just add it:
>    alter table foo add column new_col text;
> adds a new character column.
> What do you think a "delimiter field" is?
adding a field to a delimited record involves putting an extra delimiter
(I use |) at the end of each record exported from postgresql into a
file. this creates a new blank field to match the table which by now
has had a new field added.

I actually use Kexi to work on the database, and I know think that it is
kexi that enforces this requirement. ie go to the kexi design and add in
a field will total the existing data. If my memory is correct a warning
comes up when you try to save the revised design.

I don't know why, never had this with Paradox (there's history for


> -- 
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:

In response to

pgsql-novice by date

Next:From: Csanyi PalDate: 2012-08-11 13:21:04
Subject: Re: To get a Table or View like a Calendar with dates
Previous:From: Thomas KellererDate: 2012-08-10 08:16:27
Subject: Re: adding a field

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group