On Mar 16, 12:08 pm, t...@wildenhain.de (Tino Wildenhain) wrote:
> > 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?
Enter psql with '-E' flag, and see the
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
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
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