| postgres=# select * from pg_class; relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relp ages | reltuples | relallvisible | reltoastrelid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relh asoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relrowsecurity | relforcerowsecurity | relispopulated | relrepl ident | relfrozenxid | relminmxid | relacl | reloptions -----------------------------------------+--------------+---------+-----------+----------+-------+-------------+---------------+----- -----+-----------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+----- -------+------------+-------------+----------------+----------------+----------------+---------------------+----------------+-------- ------+--------------+------------+----------------------------------------------------------------+------------------------- t1 | 2200 | 24581 | 0 | 10 | 0 | 24579 | 0 | 0 | 0 | 0 | 0 | f | f | p | r | 1 | 0 | f | f | f | f | f | f | f | t | d | 1761 | 1 | | pg_statistic | 11 | 11397 | 0 | 10 | 0 | 2619 | 0 | 16 | 384 | 16 | 2840 | t | f | p | r | 26 | 0 | f | f | f | f | f | f | f | t | n | 1750 | 1 | {"\"ck0911.kim\"=arwdDxt/\"ck0911.kim\""} | pg_type | 11 | 71 | 0 | 10 | 0 | 0 | 0 | 9 | 359 | 9 | 0 | t | f | p | r | 30 | 0 | t | f | f | f | f | f | f | t | n | 1750 | 1 | {"=r/\"ck0911.kim\"","\"ck0911.kim\"=arwdDxt/\"ck0911.kim\""} | pg_toast_2604 | 99 | 11643 | 0 | 10 | 0 | 2830 | 0 | 0 | 0 | 0 | 0 | t | f | p | t | 3 | 0 | f | f | f | f | f | f | f | t | n | 1750 | 1 | | pg_toast_2604_index | 99 | 0 | 0 | 10 | 403 | 2831 | 0 | 1 | 0 | 0 | 0 | f | f | p | i | 2 | 0 | f | f | f | f | f | f | f | t | n | 0 | 0 | | pg_toast_2606 | 99 | 11644 | 0 | 10 | 0 | 2832 | 0 | 0 | 0 | 0 | 0 | t | f | p | t | 3 | 0 | f | f | f | f | f | f | f | t | n | 1750 | 1 | | pg_toast_2606_index | 99 | 0 | 0 | 10 | 403 | 2833 | 0 | 1 | 0 | 0 | 0 | f | f | p | i | 2 | 0 | f | f | f | f | f | f | f | t | n | 0 | 0 | | pg_toast_2609 | 99 | 11645 | 0 | 10 | 0 | 2834 | 0 | 0 | 0 | 0 | 0 | t | f | p | t | 3 | 0 | f | f | f | f | f | f | f | t | n | 1750 | 1 | | pg_toast_2609_index | 99 | 0 | 0 | 10 | 403 | 2835 | 0 | 1 | 0 | 0 | 0 | f | f | p | i | 2 | 0 | f | f | f | f | f | f | f | t | n | 0 | 0 | | pg_toast_1255 | 99 | 11646 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | t | f | p | t | 3 | 0 | f | f | f | f | f | f | f | t | n |
보기 불편할때가 많다.
세로로 표시를 해주면 좋겠다 라는 생각을 할때가 많다.
다행히 PostgreSQL 에서는 세로로 출력해주는 기능이 있다.
아래와 같이 세로로 변경할 수 있다.
postgres=# \x
Expanded display is on.
| postgres=# select * from pg_class; -[ RECORD 1 ]-------+--------------------------------------------------------------- relname | t1 relnamespace | 2200 reltype | 24581 reloftype | 0 relowner | 10 relam | 0 relfilenode | 24579 reltablespace | 0 relpages | 0 reltuples | 0 relallvisible | 0 reltoastrelid | 0 relhasindex | f relisshared | f relpersistence | p relkind | r relnatts | 1 relchecks | 0 relhasoids | f relhaspkey | f relhasrules | f relhastriggers | f relhassubclass | f relrowsecurity | f relforcerowsecurity | f relispopulated | t relreplident | d relfrozenxid | 1761 relminmxid | 1 relacl | reloptions | -[ RECORD 2 ]-------+--------------------------------------------------------------- relname | pg_statistic relnamespace | 11 reltype | 11397 reloftype | 0 relowner | 10 relam | 0 relfilenode | 2619 reltablespace | 0 relpages | 16 reltuples | 384 relallvisible | 16 reltoastrelid | 2840 relhasindex | t relisshared | f relpersistence | p relkind | r relnatts | 26 relchecks | 0 relhasoids | f relhaspkey | f relhasrules | f relhastriggers | f relhassubclass | f relrowsecurity | f relforcerowsecurity | f relispopulated | t relreplident | n relfrozenxid | 1750 relminmxid | 1 relacl | {"\"ck0911.kim\"=arwdDxt/\"ck0911.kim\""} reloptions | -[ RECORD 3 ]-------+--------------------------------------------------------------- relname | pg_type relnamespace | 11 reltype | 71 reloftype | 0 relowner | 10 relam | 0 relfilenode | 0 reltablespace | 0 relpages | 9 reltuples | 359 relallvisible | 9 |
다시 원래대로 돌리고 싶다면 한번 더 입력하면 된다.
postgres=# \x
Expanded display is off.
댓글 없음:
댓글 쓰기