Probably this is resolving of just binding as character.
Not related with like some escape sequences or special characters.
In Mac OS bind Option + a
Magic words:
psql -U postgres
Some interesting flags (to see all, use -h
or --help
depending on your psql version):
-E
: will describe the underlaying queries of the \
commands (cool for learning!)-l
: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)This guide assumes you're working on a Unix-like environment. I'm using Linux Mint (Ubuntu). It should work on Macs, and might on Windows.
These are the four steps you can use as a checklist, see the headings below for the details on each step.
~/.authinfo.gpg
-- | |
-- Change database owner | |
-- | |
ALTER DATABASE "db_name" OWNER TO user; | |
-- | |
-- List schemas | |
-- |