PostgreSQL: Enlarge varchar field size without changing data.

UPDATE pg_attribute SET atttypmod = 35+4 /*always use "newsize + 4" for varchars*/ WHERE attrelid = 'MYTABLE'::regclass AND attname = 'MYCOL';

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.