By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
CREATE INDEX
| logid | jobid | time | logtext |
|---|---|---|---|
| 1 | 1 | 2024-03-05 09:16:21.122827 | logtext1 |
INSERT 0 1
CREATE TABLE
| id | logid |
|---|---|
| 1 | 1 |
INSERT 0 1
| table_schema | table_name | column_name | data_type | udt_name | column_default | is_identity | identity_generation | identity_start | identity_increment | identity_maximum | identity_minimum |
|---|---|---|---|---|---|---|---|---|---|---|---|
| public | linked_to_log | id | bigint | int8 | null | YES | BY DEFAULT | 1 | 1 | 9223372036854775807 | 1 |
| public | linked_to_log | logid | integer | int4 | null | NO | null | null | null | null | null |
| public | log | logid | integer | int4 | nextval('log_logid_seq'::regclass) | NO | null | null | null | null | null |
| public | log | jobid | integer | int4 | null | NO | null | null | null | null | null |
| public | log | time | timestamp without time zone | timestamp | null | NO | null | null | null | null | null |
| public | log | logtext | text | text | null | NO | null | null | null | null | null |
SELECT 6
ALTER TABLE
| pg_get_serial_sequence |
|---|
| public.log_logid_seq |
SELECT 1
ALTER SEQUENCE
ALTER SEQUENCE
| logid | jobid | time | logtext |
|---|---|---|---|
| -9223372036854775807 | 1 | 2024-03-05 09:16:21.159598 | logtext2 |
INSERT 0 1
| table_schema | table_name | column_name | data_type | udt_name | column_default | is_identity | identity_generation | identity_start | identity_increment | identity_maximum | identity_minimum |
|---|---|---|---|---|---|---|---|---|---|---|---|
| public | linked_to_log | id | bigint | int8 | null | YES | BY DEFAULT | 1 | 1 | 9223372036854775807 | 1 |
| public | linked_to_log | logid | integer | int4 | null | NO | null | null | null | null | null |
| public | log | logid | bigint | int8 | nextval('log_logid_seq'::regclass) | NO | null | null | null | null | null |
| public | log | jobid | integer | int4 | null | NO | null | null | null | null | null |
| public | log | time | timestamp without time zone | timestamp | null | NO | null | null | null | null | null |
| public | log | logtext | text | text | null | NO | null | null | null | null | null |
SELECT 6
| sequence_catalog | sequence_schema | sequence_name | data_type | numeric_precision | numeric_precision_radix | numeric_scale | start_value | minimum_value | maximum_value | increment | cycle_option |
|---|---|---|---|---|---|---|---|---|---|---|---|
| postgres | public | log_logid_seq | bigint | 64 | 2 | 0 | -9223372036854775807 | -9223372036854775807 | 9223372036854775807 | 1 | NO |
SELECT 1
| schemaname | sequencename | sequenceowner | data_type | start_value | min_value | max_value | increment_by | cycle | cache_size | last_value |
|---|---|---|---|---|---|---|---|---|---|---|
| public | linked_to_log_id_seq | postgres | bigint | 1 | 1 | 9223372036854775807 | 1 | f | 1 | 1 |
| public | log_logid_seq | postgres | bigint | -9223372036854775807 | -9223372036854775807 | 9223372036854775807 | 1 | f | 1 | -9223372036854775807 |
SELECT 2
ALTER TABLE
| table_schema | table_name | column_name | data_type | udt_name | column_default | is_identity | identity_generation | identity_start | identity_increment | identity_maximum | identity_minimum |
|---|---|---|---|---|---|---|---|---|---|---|---|
| public | linked_to_log | id | bigint | int8 | null | YES | BY DEFAULT | 1 | 1 | 9223372036854775807 | 1 |
| public | linked_to_log | logid | bigint | int8 | null | NO | null | null | null | null | null |
| public | log | logid | bigint | int8 | nextval('log_logid_seq'::regclass) | NO | null | null | null | null | null |
| public | log | jobid | integer | int4 | null | NO | null | null | null | null | null |
| public | log | time | timestamp without time zone | timestamp | null | NO | null | null | null | null | null |
| public | log | logtext | text | text | null | NO | null | null | null | null | null |
SELECT 6