Alter character varying column's length in PostgreSQL

Question

I have table in production which has column type character varying(255);

All rows has entry in that column no longer than 15 characters and never will be larger as well. I decide to reduce its size to 15 characters with following command which I found on sof:

ALTER TABLE user_template ALTER COLUMN "TYPE" character varying(15);

I got following error:

ERROR:  syntax error at or near "character"
LINE 1: ...LTER TABLE user_template ALTER COLUMN "type" character ...
                                                        ^

Can you help me to fix it? Thanks.

What is the column name?

McNets
– McNets

2018-03-07 16:53:30 +00:00
Commented Mar 7, 2018 at 16:53 — McNets
– McNets, Commented Mar 7, 2018 at 16:53
type, its in quotes because of type is reserved key

Aligator
– Aligator

2018-03-07 16:56:37 +00:00
Commented Mar 7, 2018 at 16:56 — Aligator
– Aligator, Commented Mar 7, 2018 at 16:56

McNets · Accepted Answer · 2018-03-07 16:54:21Z

12

create table user_template (field1 varchar(255));

✓

ALTER TABLE user_template ALTER COLUMN field1 TYPE varchar(15);

✓

dbfiddle here

answered Mar 7, 2018 at 16:54

McNets

10.9k3 gold badges39 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

Alter character varying column's length in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related