pg_class where relname='rates'
update pg_attribute set attname=lower(attname) where attnum >0 and
attrelid= ( from above query)
to rename the columns in the system catalogs or will this come back and bite
me later?
Tony Cade
I have an Access database that I have exported to PostgreSQL via ODBC, which
has worked ok & the data is in PostgreSQL but some of the column names were
in mixed case e.g. AccountCode
When I look at the table definitions in pgadmin these are shown in quotes
e.g."AccountCode" and any queries made t
your_schema_name*' and
> c.table_name=t.tablename and c.table_schema=t.schemaname and c.column_name
> <>lower(c.column_name)" | psql *your_db_name
> *
>
Thank you for your suggestion I will try it.
Tony Cade
>
> --
> *From:* [EM
