alter multiple tables

From: "Kodok Marton" <marton(at)mybusinessanywhere(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: alter multiple tables
Date: 2009-03-16 15:44:36
Message-ID: 9DBB01421A394206908CBE913C8074C6@martondesktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have in every table columns like:
username character varying(20) NOT NULL

I want to extend the length of varchar in all tables.

Since I have a lot of tables and mirrored backups, I am wondering if there is a way to alter automatically all tables where colname matches 'username'

Is there a way to do this?

Marton

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2009-03-16 16:08:09 Re: alter multiple tables
Previous Message dcrespo 2009-03-16 14:53:39 archive_command question