How to rename the same column name in dozens of tables in Postgres?

From: Stefan Schwarzer <stefan(dot)schwarzer(at)unep(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: How to rename the same column name in dozens of tables in Postgres?
Date: 2013-12-17 07:59:42
Message-ID: 3650E852-12F1-42D2-9AC9-E200E1453E8D@unep.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there,

I have dozens of tables where I need to rename one column in each of these. Is there any generic way to do that?

I am not really familiar with the scripting possibilities of Postgres.

Thanks a lot for your help!

Stefan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rahila Syed 2013-12-17 08:49:10 Re: Replication: GZIP compression in WAL sender/receiver processes communication?
Previous Message Rahila Syed 2013-12-17 07:34:48 Re: Replication: GZIP compression in WAL sender/receiver processes communication?