| public getDomainConstraints ( $domain ) : A | ||
| $domain | The name of the domain whose constraints to fetch | |
| Результат | A | recordset |
function getDomainConstraints($domain)
{
$c_schema = $this->_schema;
$this->clean($c_schema);
$this->clean($domain);
$sql = "\n\t\t\tSELECT\n\t\t\t\tconname,\n\t\t\t\tcontype,\n\t\t\t\tpg_catalog.pg_get_constraintdef(oid, true) AS consrc\n\t\t\tFROM\n\t\t\t\tpg_catalog.pg_constraint\n\t\t\tWHERE\n\t\t\t\tcontypid = (\n\t\t\t\t\tSELECT oid FROM pg_catalog.pg_type\n\t\t\t\t\tWHERE typname='{$domain}'\n\t\t\t\t\t\tAND typnamespace = (\n\t\t\t\t\t\t\tSELECT oid FROM pg_catalog.pg_namespace\n\t\t\t\t\t\t\tWHERE nspname = '{$c_schema}')\n\t\t\t\t)\n\t\t\tORDER BY conname";
return $this->selectSet($sql);
}