[PostgreSQL] よく使うコマンドまとめ

			
			$ psql —version
		

			
			# select version();　
		

			
			$ psql --help
		

			
			# \?
		

			
			# \h
		

			
			$ psql <DB_NAME>
		

			
			$ psql -U <USER_NAME> <DB_NAME>
		

			
			# \q
		

			
			$ postgres -D /usr/local/var/postgres
		

			
			$ psql -l
		

			
			# \l
		

			
			# \c <DB_NAME>
		

			
			# \connect <DB_NAME>
		

			
			# drop database <DATABASE_NAME>;
		

			
			# \d
		

			
			# \dt
		

			
			# \d <TABLE_NAME>
		

			
			# \z <TABLE_NAME>
		

			
			# \dv
		

			
			# select definition from pg_views where viewname = '<VIEW_NAME>';
		

			
			# alter table <CURRENT_DB_NAME> rename to <NEW_DB_NAME>;
		

			
			# drop table <TABLE_NAME>;
		

			
			# select current_user;
		

			
			# \du
		

			
			# select * from pg_user;
		

			
			# grant select, insert, update, delete on <TABLE_NAME> to <USER_NAME>;
		

			
			# revoke select, insert, update, delete on <TABLE_NAME>　from <USER_NAME>;
		

			
			# \connect - <USER_NAME>
		

			
			# alter role <USER_NAME> with creatural superuser;
		

			
			# alter role <USER_NAME> with creatural nosuperuser;
		

			
			# create schema <schema_name>;
		

			
			# select current_schema;
		

			
			# \dn
		

			
			# set search_path to <schema_name>;