「PostgreSQLでよくやること」の版間の差分

$ pg_dump <DATABASE_NAME> > <FILE_NAME>

$ psql <DATABASE_NAME>< infile

# \du

# CREATE ROLE <ROLE_NAME> WITH LOGIN PASSWORD '<PASSWORD>';

# ALTER ROLE <OLD_ROLE_NAME>TO <NEW_ROLE_NAME>

# DROP ROLE <ROLE_NAME>;

# \l

# \c <DABASE_NAME>

# create database  <DABASE_NAME>;

# create database <DABASE_NAME> owner <OWNER_NAME>;

# drop database <DATABASE_NAME>;

# \d

# \dt

# drop table <TABLE_NAME>;

# \dn

# select current_schema;

# set search_path to <SCHEMA_NAME>;