Re: Changing column types

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 of
>  doing this.
>
> Is there any way, using the system catalogues - pg_tables, pg_attributes
> etc that I can automatically change all text type fields to varchar or
> am I better of just recreating the schema?
>

Ignore this message, I've found a solution on the ODBC side.

--
Paul Lambert
Database Administrator
AutoLedgers