Postgres Pro
Downloads
Home   >   mailing lists

alter multiple tables - Mailing list pgsql-general

From Kodok Marton
Subject alter multiple tables
Date
Msg-id 9DBB01421A394206908CBE913C8074C6@martondesktop
Whole thread Raw
Responses Re: alter multiple tables  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
Tree view
Hello,
 
I have in every table columns like:
usernamecharacter 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

pgsql-general by date:

Previous
From: dcrespo
Date:
Subject: archive_command question
Next
From: Tino Wildenhain
Date:
Subject: Re: alter multiple tables