xxxxxxxxxx
ALTER TABLE {your_table} REPLICA IDENTITY USING index;
xxxxxxxxxx
SELECT CASE relreplident
WHEN 'd' THEN 'default'
WHEN 'n' THEN 'nothing'
WHEN 'f' THEN 'full'
WHEN 'i' THEN 'index'
END AS replica_identity
FROM pg_class
WHERE oid = '{your_table}'::regclass;