add batch remove batch split batch comment selection show hidden batches hide batch
db<>fiddle
donate feedback about
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:11:19.313257 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
logid jobid time logtext
2 1 2024-03-05 09:11:19.358567 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 1 1 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 1 1 9223372036854775807 1 f 1 2 
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