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

Re: adding a field

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: adding a field
Date: 2012-08-10 08:16:27
Message-ID: k02g0f$u1v$1@dough.gmane.org (view raw or flat)
Thread:
Lists: pgsql-novice
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?






In response to

Responses

pgsql-novice by date

Next:From: Anne WainwrightDate: 2012-08-10 11:55:46
Subject: Re: adding a field
Previous:From: Anne WainwrightDate: 2012-08-10 08:04:09
Subject: adding a field

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