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

Re: Problems

2001-10-25 Thread Dave Page
> -Original Message- > From: Eric Day [mailto:[EMAIL PROTECTED]] > Sent: 25 October 2001 17:35 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Problems > > > Hi, > > I've just downloaded & installed PostgresSql 7.1.3 & > pgAdmin II 1.1.59. Postgresql is up and running, an