public function getTables()
{
$tables = [];
foreach ($this->connection->query("\n\t\t\tSELECT DISTINCT ON (c.relname)\n\t\t\t\tc.relname::varchar AS name,\n\t\t\t\tc.relkind IN ('v', 'm') AS view,\n\t\t\t\tn.nspname::varchar || '.' || c.relname::varchar AS \"fullName\"\n\t\t\tFROM\n\t\t\t\tpg_catalog.pg_class AS c\n\t\t\t\tJOIN pg_catalog.pg_namespace AS n ON n.oid = c.relnamespace\n\t\t\tWHERE\n\t\t\t\tc.relkind IN ('r', 'v', 'm')\n\t\t\t\tAND n.nspname = ANY (pg_catalog.current_schemas(FALSE))\n\t\t\tORDER BY\n\t\t\t\tc.relname\n\t\t") as $row) {
$tables[] = (array) $row;
}
return $tables;
}