Re: a problem

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