PostgreSQL: Enlarge varchar field size without changing data.

1
2
UPDATE pg_attribute SET atttypmod = 35+4 /*always use "newsize + 4" for varchars*/
WHERE attrelid = 'MYTABLE'::regclass
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

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.