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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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