Re: [GENERAL] Changing column types

2007-08-05 Thread Paul Lambert
Paul Lambert wrote: Owing to a problem with the way access and a couple of other programs I've found handle text columns in PG as something they call 'memo', I want to change all of the text columns in my database to varchar. There's about 600 text columns all up, so I'm looking for a quick way

[GENERAL] Changing column types

2007-08-05 Thread Paul Lambert
Owing to a problem with the way access and a couple of other programs I've found handle text columns in PG as something they call 'memo', I want to change all of the text columns in my database to varchar. There's about 600 text columns all up, so I'm looking for a quick way of doing this. I