How to set an endless character Datatype in a Postgres Database table?

Question

I have this database table in postgres:

CREATE TABLE dummytable (
     id bigint NOT NULL,
     fieldvalue character varying(255)
)

How can i changed the datatype of the field "fieldvalue" to an endless character datatype? Is that possible?

Clodoaldo Neto · Accepted Answer · 2014-02-06 11:12:51Z

1

Use the text data type

CREATE TABLE dummytable (
     id bigint NOT NULL,
     fieldvalue text
)

To alter an existent table

alter table dummytable
alter column fieldvalue
set data type text;

answered Feb 6, 2014 at 10:59

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Or varchar without a length.

ok thanks, how can i set this field datatype with an sql update statements?

NiiL · Accepted Answer · 2014-02-06 11:08:39Z

0

ALTER TABLE dummytable ALTER COLUMN fieldvalue TYPE TEXT;

For more ALTER TABLE option see this link: PostgreSQL - Alter Table

answered Feb 6, 2014 at 11:08

NiiL

2,8371 gold badge28 silver badges37 bronze badges