| protected findSchemaNames ( ) : array | ||
| return | array | all schema names in the database, except system schemas |
protected function findSchemaNames()
{
$sql = <<<SQL
SELECT ns.nspname AS schema_name
FROM pg_namespace ns
WHERE ns.nspname != 'information_schema' AND ns.nspname NOT LIKE 'pg_%'
ORDER BY ns.nspname
SQL;
return $this->db->createCommand($sql)->queryColumn();
}