これは、HEROKUのHEROKU CONNECTのDATABASEに書かれていたもの。
Psql command line tips
- Establish a connection to your database
$ heroku pg:psql DATABASE_URL --app evening-ridge
- List tables in the connect schema:
# \dt salesforce.*;
- Query from a table:
# select * from salesforce.account;
- Set the search path:
# set search_path=salesforce, public;
- Show the list of all schemas
# \dn