Length of Varchar

From: Andre Schubert <andre(at)km3(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Length of Varchar
Date: 2003-01-24 06:37:09
Message-ID: 20030124073709.7f2b1524.andre@km3.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

i have a little question on changing the length of a varchar field.
Is there another way than dump and reload if i want to change the length
of a varchar field ?
I have search the idocs and found some docs about the system-table pg_attribute,
where the length of a varchar-field is stored in atttypmod.
Is it possible to change the value of atttypmod and is it safe to change this
value?

Thanks in advance

as

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ian Barwick 2003-01-24 08:26:45 Re: Length of Varchar
Previous Message Lamar Owen 2003-01-24 02:18:41 Re: Installing PG 7.3 on stock RH 7.3