add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
constraint_catalog constraint_schema constraint_name unique_constraint_catalog unique_constraint_schema unique_constraint_name match_option update_rule delete_rule
db_1004412549 public test_def_abc_fkey null null null NONE NO ACTION NO ACTION
constraint_catalog constraint_schema constraint_name table_catalog table_schema table_name column_name ordinal_position position_in_unique_constraint
db_1004412549 public test_def_abc_fkey db_1004412549 public test_def abc_id 1 1
db_1004412549 public test_def_abc_fkey db_1004412549 public test_def abc_id2 2 2
conname fk_table fk_columns ref_table ref_key_columns
test_def_abc_fkey test_def {abc_id,abc_id2} test_abc {id,id2}