Postgres Pro
Downloads
Home   >   mailing lists

Re: Altering Column Date Types - Mailing list pgsql-novice

From Aarni Ruuhimäki
Subject Re: Altering Column Date Types
Date
Msg-id 200301251949.36315.aarni.ruuhimaki@kymi.com
Whole thread Raw
In response to Altering Column Date Types  (Desmond Coughlan <psql@zeouane.org>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Desmond Coughlan
Date:
Subject: Re: Can't read input file
Next
From: "Reshat Sabiq"
Date:
Subject: Re: localhost connects, same code on other host fails