Re: alter multiple tables

[Tino Wildenhain <tino@xxxxxxxxxxxxx>]

Hi,

Kodok Marton wrote:
> 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.

next time you should probably consider using a domain type
(or stick to text)

> 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?

It should be possible to generate a list of tables either via
query or using pg_dump -L with grep and create SQL based on this
(with a script, unix shell) and execute it against the database.

(Test this of course)

HTH
Tino

<<attachment: smime.p7s>>