Re: a problem

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: sharvari N <sharvari_n(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: a problem
Date: 2003-08-25 13:10:26
Message-ID: 1061817026.4596.209.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Fri, 2003-08-22 at 05:01, sharvari N wrote:
> hello
> How do i change the definition of a column? one of the columns width is
> not sufficient to store the data. I want to change the width. how to do
> that in postgres? I tried doing alter table + change/modify. both of
> them doesn't work in postgres.

you have to hack the system tables for this, though i can't seem to
recall the exact field name this morning. the query is certainly in the
archives as i've answered this one before, if you were too lazy to look
it up i guess i will be too ;-)

> and what is the maximum size to which a postgres database can grow? I
> have huge data to store.

real big, most likely limited by your OS. i think the largest reported
is like 4TB

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

  • a problem at 2003-08-22 09:01:13 from sharvari N

Browse pgsql-admin by date

  From Date Subject
Next Message Hornyak Laszlo 2003-08-25 13:15:44 postgres hab modification without restarting
Previous Message maillist 2003-08-25 12:45:20 Re: System Tables

Browse pgsql-general by date

  From Date Subject
Next Message David MAHE 2003-08-25 13:32:38 greek char
Previous Message Florian Weimer 2003-08-25 11:19:44 Re: The ..... worm