Symfony Profiler

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type != 'VIEW'

SELECT quote_ident(table_name) AS table_name,
                       table_schema AS schema_name
                FROM   information_schema.tables
                WHERE  table_schema NOT LIKE 'pg\_%'
                AND    table_schema != 'information_schema'
                AND    table_name != 'geometry_columns'
                AND    table_name != 'spatial_ref_sys'
                AND    table_type != 'VIEW';

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.name AS name_2,
  s0_.icon AS icon_3
FROM
  standarisasi s0_
ORDER BY
  s0_.sequence ASC

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.name AS name_2, s0_.icon AS icon_3 FROM standarisasi s0_ ORDER BY s0_.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.sequence AS sequence_5,
  t0.standarisasi_id AS standarisasi_id_6
FROM
  standart_area t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.sequence AS sequence_5, t0.standarisasi_id AS standarisasi_id_6 FROM standart_area t0;

SELECT
  nspname
FROM
  pg_namespace
WHERE
  nspname ! ~ '^pg_.*'
  AND nspname != 'information_schema'

SELECT nspname FROM pg_namespace WHERE nspname !~ '^pg_.*' AND nspname != 'information_schema';

SHOW search_path

SHOW search_path;