[root@appserver config]# ping specdb
PING dbserver1-int (10.10.1.5) 56(84) bytes of data.
64 bytes from dbserver1-int (10.10.1.5): icmp_seq=1 ttl=64 time=2.53 ms
64 bytes from dbserver1-int (10.10.1.5): icmp_seq=2 ttl=64 time=1.82 ms
^C
--- dbserver1-int ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1308ms
rtt min/avg/max/mdev = 1.822/2.177/2.532/0.355 ms
[root@appserver config]#
[root@appserver config]# psql -h specdb -U spec -d SPECDB
psql: FATAL: database "SPECDB" does not exist
[root@appserver config]# psql -h specdb -U spec -d specdb
psql (9.2.5)
输入 "help" 来获取帮助信息.
specdb=# \d
关联列表
架构模式 | 名称 | 型别 | 拥有者
----------+----------------------+--------+--------
public | c_customer | 资料表 | spec
public | c_customerinventory | 资料表 | spec
public | c_parts | 资料表 | spec
public | c_site | 资料表 | spec
public | c_supplier | 资料表 | spec
public | m_bom | 资料表 | spec
public | m_inventory | 资料表 | spec
public | m_largeorder | 资料表 | spec
public | m_parts | 资料表 | spec
public | m_workorder | 资料表 | spec
public | o_item | 资料表 | spec
public | o_orderline | 资料表 | spec
public | o_orders | 资料表 | spec
public | s_component | 资料表 | spec
public | s_purchase_order | 资料表 | spec
public | s_purchase_orderline | 资料表 | spec
public | s_site | 资料表 | spec
public | s_supp_component | 资料表 | spec
public | s_supplier | 资料表 | spec
public | txn_log_table | 资料表 | spec
public | u_sequences | 资料表 | spec
(21 行记录)
specdb=# \q