Re: adding a field - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: adding a field
Date
Msg-id k02g0f$u1v$1@dough.gmane.org
Whole thread Raw
In response to adding a field  (Anne Wainwright <anotheranne@fables.co.za>)
Responses Re: adding a field
List 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?





pgsql-novice by date:

Previous
From: Anne Wainwright
Date:
Subject: adding a field
Next
From: Anne Wainwright
Date:
Subject: Re: adding a field