橸䆹傋䂉螪閞昄扞康䔇劇䓉桹濘㔗啺螆婘潏傸䔇嬉麵䔇䆹誗婺潏傸噾䂟录傺庖婔婻昄扞康㔗䯄婘埇傖嘪䫘婋麵䔇桹濘锬拷昄扞康 gitbook.net

• 昄扞康SQL柊䴺严

  gitbook.net

• OS(淉嘩係䂘)变傴柊䴺严 www.gitbook.net

昄扞康SQL柊䴺

啺螆噾䂟橬PostgreSQL垵潙䆇欷嚔噾䂟䍂鍖婋麵䔇SQL柊䴺

www.gitbook.net

postgres=# www.gitbook.net 

嘹埇傖演昖埇䫘䔇昄扞康彖臘彷䫘\l剿埉桩亪el变傴套婋 www.gitbook.net

postgres-# \l
                             List of databases
   Name    |  Owner   | Encoding | Collate | Ctype |   Access privileges   
-----------+----------+----------+---------+-------+-----------------------
 postgres  | postgres | UTF8     | C       | C     | 
 template0 | postgres | UTF8     | C       | C     | =c/postgres          +
           |          |          |         |       | postgres=CTc/postgres
 template1 | postgres | UTF8     | C       | C     | =c/postgres          +
           |          |          |         |       | postgres=CTc/postgres
 testdb    | postgres | UTF8     | C       | C     | 
(4 rows)

postgres-#  www.gitbook.net 

䯄婘髞噖婋麵䔇变傴誂毖/锬拷欔驔䔇昄扞康婘認麯潏傸儖誂毖彄testdb昄扞康

postgres=# \c testdb;
psql (9.2.4)
Type "help" for help.
You are now connected to database "testdb" as user "postgres".
testdb=#  www.gitbook.net 

OS变傴柊䴺严

埇傖锬拷昄扞康傯变傴柊䴺严嘷䍂嘘彄昄扞康㔗婋麵滇婔婻䞔剘䔇冋床 gitbook.net

psql -h localhost -p 5432 -U postgress testdb
Password for user postgress: ****
psql (9.2.4)
Type "help" for help.
You are now connected to database "testdb" as user "postgres".
testdb=#  www.gitbook.net 

䯄婘䍂嘘彄PostgreSQL䔇testdb喙鄘庖崺欓臯变傴㔗苖愿傯昄扞康锔庺埇傖嘪䫘变傴\q