| From: | Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Changing column types |
| Date: | 2007-08-05 23:54:46 |
| Message-ID: | 46B66346.7030809@autoledgers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Perry Smith | 2007-08-05 23:58:33 | Re: pg_dump of only the structure from a client such as ruby |
| Previous Message | Michael Glaesemann | 2007-08-05 23:07:43 | Re: pg_dump of only the structure from a client such as ruby |