Re: Problems changing type of column using pgAd

2001-12-18 Thread Henshall, Stuart - WCP
The DROP columns and changing types is not trivially possible using PostgreSQL. To do it you basically need to recreate the table with the new data then COPY or INSERT he old data back in. pg_dump is handy for getting a table out in a suitable script for editing. Also I believe you can Sav

Re: Problems changing type of column using pgAd

2001-12-18 Thread Dave Page
> -Original Message- > From: Timon Meyer [mailto:[EMAIL PROTECTED]] > Sent: 18 December 2001 14:41 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Problems changing type of column > using pgAdmin... > > > Hello, > > I am a beginner in using the pgAdmin for Windows and I have fo