private string[] primaryKeysFor(IDocumentMapping documentMapping)
{
var sql = @"
select a.attname, format_type(a.atttypid, a.atttypmod) as data_type
from pg_index i
join pg_attribute a on a.attrelid = i.indrelid and a.attnum = ANY(i.indkey)
where attrelid = (select pg_class.oid
from pg_class
join pg_catalog.pg_namespace n ON n.oid = pg_class.relnamespace
where n.nspname = ? and relname = ?)
and i.indisprimary;
";
return(_tenant.GetStringList(sql, documentMapping.Table.Schema, documentMapping.Table.Name).ToArray());
}
