postgreSQL

[スタート]→[プログラム]→[PostgreSQL 8.1]→[psqlでtemplate1へ接続]でpsqlを起動できる。
http://web.sfc.keio.ac.jp/~k12u/lecture/pgsql_win.html

# psql dbname
dbname==> copy tablename to '/home/postgres/table.back';

dbname==> drop table tablename;

dbname==> create table tablename (date timestamp, number integer, field text, primary key (date, number));

dbname==> copy tablename from '/home/postgres/table.back';

dbname==> select * from tablename;
dbname==> \q

# pqql dbname
dbname==> \z


　　　　　Access permissions for database "u_comm"
Relation | Access permissions
--------------+--------------------------------------------
table_a　　　| {"=","httpd=r","palmyra=arwR","root=arwR"}
table_b　　　| {"=arwR"}
table_c　　　| {"=","httpd=arwR"}
(3 rows)

dbname==> grant all on table_c to public；
dbname==> \z


　　　　　Access permissions for database "u_comm"
Relation | Access permissions
--------------+--------------------------------------------
table_a　　　| {"=","httpd=r","palmyra=arwR","root=arwR"}
table_b　　　| {"=arwR"}
table_c　　　| {"=arxR","httpd=arwR"}
(3 rows)


r　;　select
a　;　insert
w　;　update/delete
R　;　rule