Repear operations on 50 tables of the same schema?

Поиск
Список
Период
Сортировка
От celati Laurent
Тема Repear operations on 50 tables of the same schema?
Дата
Msg-id CAHByMH36q6OCCKZWJML4vT6cq1aADSi-wghue_7qOcG-tbLcDQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Repear operations on 50 tables of the same schema?  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general

Good morning,
I am new to Postgresql. I have 50 tables into a "ign" schema (schema other than public).
I would like for each of these 50 tables:

- Add a prefix to the name of the table: "IGN_bdTopo_"
- Add a suffix to the table name: "_V1"
- create a new "date" column of date type. And populate this field with the value: 06/15/2021
- create a new "source" column of type varchar (length 50). And populate this field with the value: 'ign'.
- move all the elements of these 50 tables (including all). from the "ign" schema to the "ign_v2" schema. Whether data, constraints, indexes.

If someone could  help me? Thank you so much.

В списке pgsql-general по дате отправления:

Предыдущее
От: PALAYRET Jacques
Дата:
Сообщение: Re: Interval in hours but not in days Leap second not taken into account
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: ERROR: unsupported Unicode escape sequence - in JSON-type column