I
I
Ilya2014-08-29 20:29:43
PostgreSQL
Ilya, 2014-08-29 20:29:43

PostgreSQL: how to remove string length limit?

When creating the table, I set character varying(50), but it should be 250. How to fix it in the ubuntu console? Russia database, video table, title column. If possible, then direct code or link.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
Ilya, 2014-08-29
@FireGM

ALTER TABLE video ALTER COLUMN title TYPE varchar(20) USING title::varchar(250);

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question