Re: Sequence Manipulation Functions

On Jan 10 03:56, MG wrote:
> I noticed that the phpPgAdmin has that information
>
>       Name Last value Increment by Max value Min value Cache value Log count Is cycled? Is called?
>       adr_dsnr 108 1 9223372036854775807 1 1 25 No Yes

test=# \d roomsold_main_id_seq
Sequence "public.roomsold_main_id_seq"
    Column     |  Type
---------------+---------
 sequence_name | name
 last_value    | bigint
 increment_by  | bigint
 max_value     | bigint
 min_value     | bigint
 cache_value   | bigint
 log_cnt       | bigint
 is_cycled     | boolean
 is_called     | boolean

test=# \x
Expanded display is on.
test=# SELECT sequence_name, last_value, increment_by, max_value,
test-#        min_value, cache_value, log_cnt, is_cycled, is_called
test-# FROM roomsold_main_id_seq;
-[ RECORD 1 ]-+---------------------
sequence_name | roomsold_main_id_seq
last_value    | 1
increment_by  | 1
max_value     | 9223372036854775807
min_value     | 1
cache_value   | 1
log_cnt       | 1
is_cycled     | f
is_called     | f


HTH.
Regards.