How to get the increment of the created sequence?

Question

PostgreSQL

Created an example sequence

create sequence public.example minvalue 2000 start 2000 increment 1000;

How can I find out increment by query?

Answer 1

information_schema.sequences is the correct answer, only the schema name should also be taken into account so as not to accidentally get several lines from different schemas.
In postgresql 10+, you can access the system directory like this
Before release 10, look at (not at hand to specify the field name) But if postgresql implementation details are not needed, then information_schema.sequences will probably be more appropriate. unlikely to change in major releases.