Re: Altering Column Date Types

From: Aarni Ruuhimäki <aarni(dot)ruuhimaki(at)kymi(dot)com>
To: Desmond Coughlan <psql(at)zeouane(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Altering Column Date Types
Date: 2003-01-25 17:49:36
Message-ID: 200301251949.36315.aarni.ruuhimaki@kymi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Desmond !

I use 'pg_dump -c my_db > my_db_dump' and then edit the dump file's CREATE
TABLE statements to change column data-tytes. When done, read or re-create
the db back in with 'cat my_db_dump | psql my_db'

Just make sure your data fits into the new data-type.

BR,

Aarni

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Reshat Sabiq 2003-01-26 01:44:40 Re: localhost connects, same code on other host fails
Previous Message Desmond Coughlan 2003-01-25 13:52:00 Re: Can't read input file