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$ (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group