evolution-cms / evolution

    private function getTableWhereClause($table, $classAlias = 'c', $namespaceAlias = 'n')

    {

        $whereClause = $namespaceAlias.".nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND ";

        if (strpos($table, ".") !== false) {

            list($schema, $table) = explode(".", $table);

            $schema = $this->quoteStringLiteral($schema);

        } else {

            $schema = "ANY(string_to_array((select replace(replace(setting,'\"\$user\"',user),' ','') from pg_catalog.pg_settings where name = 'search_path'),','))";

        }

        $table = new Identifier($table);

        $table = $this->quoteStringLiteral($table->getName());

    {

        $user = 'USER_NAME()';

        if (strpos($table, '.') !== false) {

            list($user, $table) = explode('.', $table);

            $user = $this->quoteStringLiteral($user);

        }

        return "SELECT    col.column_name,

                          COALESCE(def.user_type_name, def.domain_name) AS 'type',