Re: alter multiple tables
От | Kodok Marton |
---|---|
Тема | Re: alter multiple tables |
Дата | |
Msg-id | E335D0EC06CE459994B5DAE229D41A71@martondesktop обсуждение исходный текст |
Ответ на | alter multiple tables ("Kodok Marton" <marton@mybusinessanywhere.com>) |
Список | pgsql-general |
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" <tino@wildenhain.de> To: "Kodok Marton" <marton@mybusinessanywhere.com> Cc: <pgsql-general@postgresql.org> Sent: Monday, March 16, 2009 6:08 PM Subject: Re: [GENERAL] alter multiple tables > 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 >
В списке pgsql-general по дате отправления: