| From: | "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com> |
|---|---|
| To: | joe(at)jwebmedia(dot)com, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Modify Column |
| Date: | 2000-12-01 16:31:40 |
| Message-ID: | 0012011131400S.00289@comptechnews |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Friday 01 December 2000 10:23, joe(at)jwebmedia(dot)com wrote:
> This seems like a simple enough thing, and I'm sure it's been answered,
> but I couldn't find anything that helped in the archives. Basically, I
> have a column in my table that was, once upon a time, large enough, but
> now, I need to increase the site of the column. How can I do that?
> Thanks,
>
> Joe
You can dump the database to file.sql, edit file.sql and change the size of
the column, save it, drop the database, and reload it from file.sql.
--
-------- Robert B. Easter reaster(at)comptechnews(dot)com ---------
- CompTechNews Message Board http://www.comptechnews.com/ -
- CompTechServ Tech Services http://www.comptechserv.com/ -
---------- http://www.comptechnews.com/~reaster/ ------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | martin.chantler | 2000-12-01 16:32:08 | Re: Modify Column |
| Previous Message | Peter Eisentraut | 2000-12-01 16:23:31 | Re: Unanswered questions about Postgre |