On Sat, 2009-01-10 at 17:25 -0500, Bruno Lavoie wrote: > Hello, > > In a migration process, I've imported a bunch of tables from an old > Access database to PostgreSQL. The name of tables and fields on the > source are mixed case. When copying tables to pg via ODBC, identifiers > are copied in mixed case into pg destination db. Data is copied without > any problem. > > Due to pg folding policies, I always need to quote my identifiers when > querying data on these tables. It's something overkill in typing and time. > > --> Can I rename all tables and columns to lowercase, in a specified schema?
Sure. Do this :) \o /tmp/go_to_lower select 'ALTER TABLE '||'"'||tablename||'"'||' RENAME TO ' || lower(tablename)||';' from pg_tables where schemaname = 'public'; psql -U username database < /tmp/go_to_lower Sincerely, Joshua D. Drake -- PostgreSQL Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
