【postgresql】 メタコマンドの詳細確認

psql起動時に-Eオプションをつけることで、メタコマンドが内部的に実行しているqueryを見ることが出来ます。

実行ログ

[postgres@vagrant-centos65 ~]$ /usr/local/pgsql/bin/psql test -E
psql (9.3.5)
Type "help" for help.

test=#
test=#
test=# \dt
********* QUERY **********
SELECT n.nspname as "Schema",
  c.relname as "Name",
  CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' END as "Type",
  pg_catalog.pg_get_userbyid(c.relowner) as "Owner"
FROM pg_catalog.pg_class c
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','')
      AND n.nspname <> 'pg_catalog'
      AND n.nspname <> 'information_schema'
      AND n.nspname !~ '^pg_toast'
  AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;
**************************

No relations found.
test=#

-E オプションのヘルプ

  -E, --echo-hidden        display queries that internal commands generate