Request a Demo
Home   >   mailing lists

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: - Mailing list pgsql-docs

From Greg Sabino Mullane
Subject 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:
Date
Msg-id CAKAnmmK5VkXQge6iCn4QDvnmBRrnrxcw0LLoLw3EPTpHgoPWDw@mail.gmail.com
Whole thread Raw
In response to 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>)
List pgsql-docs
Tree view
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 by date:

Previous
From: "yanliang lei"
Date:
Subject: 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:
Next
From: "David G. Johnston"
Date:
Subject: 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: