[ADMIN] Easy way to export/import a field

[Darren Greer : Information Systems]

Lo all.  This is my first posting, so I apologize if this is
in-appropriate.  I am trying to change a field inside of a table from int4
to text.  Here is what I have tried:

I create a temp table from the original.  I then drop the original table.
After that I create a new table, with the exact same names/attributes
except the one field that I change to text.  Then I do an insert, from the
temp table to the new table.  This errors out, stating that it cannot not
put int data into a text field.  

I have searched the pgsql website for this question, and have found many
posts saying that this has been answered several times, but have been
unable to find any post that actually shows how.  I would greatly
appreciate it if someone could tell me the steps to solve my dilema.  

Thanks in advance,

Darren Greer
QTI - Information Systems
(414)566-7543
[EMAIL PROTECTED]