Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-general by date

Next:From: David MAHEDate: 2003-08-25 13:32:38
Subject: greek char
Previous:From: Florian WeimerDate: 2003-08-25 11:19:44
Subject: Re: The ..... worm

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group