Adding same column to several tables.
От
Łukasz Brodziak
Тема
Adding same column to several tables.
Дата
Msg-id
DUB128-W67EFD26DEC27182E9E45319C560@phx.gbl
Список
Дерево обсуждения
Adding same column to several tables. Łukasz Brodziak <l.brodziak@outlook.com>
Re: Adding same column to several tables. hubert depesz lubaczewski <depesz@depesz.com>
Re: Adding same column to several tables. "David G. Johnston" <david.g.johnston@gmail.com>
Hello,
I have a function to add column to all tables from the list:
do
$$
declare
relnam pg_class.relname%TYPE;
kur cursor for select c.relname
from pg_class as c
inner join pg_attribute as a on a.attrelid = c.oid
where a.attname = 'some_id' and c.relkind = 'r';
begin
open kur;
LOOP
Fetch kur into relnam;
exit when not found;
EXECUTE 'ALTER TABLE '|| relnam|| ' add column another_id integer default -1';
END LOOP;
close kur;
END;
$$
I have 22 table names returned by the query used by cursor. Whe I run the function it executes for 1.5 minutes. Is there a way of doing it faster?
В списке pgsql-admin по дате отправления
От: Alvaro Herrera
Дата:
