On Wed, Oct 1, 2025 at 6:04 AM yanliang lei <[email protected]> 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 -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support
