Search Postgresql Archives
alter multiple tables
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
: <
pgsql-general@xxxxxxxxxxxxxx
>
Subject
: alter multiple tables
From
: "Kodok Marton" <
marton@xxxxxxxxxxxxxxxxxxxxxx
>
Date
: Mon, 16 Mar 2009 17:44:36 +0200
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 there a way to do this?
Marton
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: alter multiple tables
From:
Tino Wildenhain
Prev by Date:
archive_command question
Next by Date:
Re: alter multiple tables
Previous by thread:
archive_command question
Next by thread:
Re: alter multiple tables
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]