Re: URGENT!!! changing Column size

Dopping the whole database just for a column change?

On Tue, 2003-10-28 at 10:00, Theodore Petrosky wrote:

> why not just
>
> pg_dump dbname > olddb.out
> pico olddb.out
>
> edit the section that defines the table
> save and exit
>
> dropdb dbname
> createdb dbname
>
> psql dbname < olddb.out
>
> no fuss no muss...
>
> Ted
>
> --- mohan(at)physics(dot)gmu(dot)edu wrote:
> > Hi can we change the size of a column in postgres. I
> > have a table named
> > institution and column name is name varchar2(25), i
> > want to change it to
> > varchar2(50). Please let me know.
> >
> > --Mohan
> >
> >
> >
> >
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the
> > unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
> __________________________________
> Do you Yahoo!?
> Exclusive Video Premiere - Britney Spears
> http://launch.yahoo.com/promos/britneyspears/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>