Re: in the different schema ,the sequence name is same, and a table's column definition use this sequence,so,how can I identify sequence's schema name by system view/table:

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: in the different schema ,the sequence name is same, and a table's column definition use this sequence,so,how can I identify sequence's schema name by system view/table:
Дата
Msg-id CAKAnmmK5VkXQge6iCn4QDvnmBRrnrxcw0LLoLw3EPTpHgoPWDw@mail.gmail.com
обсуждение исходный текст
Ответ на in the different schema ,the sequence name is same, and a table's column definition use this sequence,so,how can I identify sequence's schema name by system view/table:  ("yanliang lei" <msdnchina@163.com>)
Список pgsql-docs
On Wed, Oct 1, 2025 at 6:04 AM yanliang lei <msdnchina@163.com> wrote:
 the column c1 in the schema_1.test_tab_100 is associated with which sequence ?? schema_1.seq_xx_yy or public.seq_xx_yy??

This is better asked on the pgsql-general mailing list, but the short answer is that you have to look at your search_path as well. Since you just created schema_1, and public is in your search_path, a plain seq_xx_yy is the one from the public schema. To see the fully-qualified name, run:

SET search_path = pg_catalog;

before issuing your select from information_schema.columns
 
Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

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