Re: [GENERAL] alter multiple tables

2009-03-16 Thread Kodok Marton
doing via shell is one way (long way if you use Windows), is it possible by updateding postgresql master tables? - Original Message - From: "Tino Wildenhain" To: "Kodok Marton" Cc: Sent: Monday, March 16, 2009 6:08 PM Subject: Re: [GENERAL] alter multiple tables

[GENERAL] alter multiple tables

2009-03-16 Thread Kodok Marton
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 th