Re: Re: Supplements and suggestions and about postgresql sequence setval function in the documents

On Wed, Aug 21, 2024 at 4:41 PM yanliang lei <msdnchina(at)163(dot)com> wrote:

> What I want to express is：
> There is no description in the document that the schema name can be
> included before the sequence name
>
>
>
Correct. It is here:

All of the OID alias types for objects that are grouped by namespace accept
schema-qualified names, and will display schema-qualified names on output
if the object would not be found in the current search path without being
qualified. For example, myschema.mytable is acceptable input for regclass
(if there is such a table). That value might be output as myschema.mytable,
or just mytable, depending on the current search path.

https://www.postgresql.org/docs/current/datatype-oid.html

David J.