# turns on/off tuples only => means no printing of headers/footers etc, just rows
psql=# \t
# turns on/off aligned output => basically pretty tables or not
psql=# \a
# sets output to some file. Turn off with another "\o"
psql=# \o FILE
# Load dump into currently connected database. Delimiter can be omitted if it's defaut one but i don't know which one is it and dump is delimited with '|'
\COPY table_name (columns) FROM dump_file DELIMITER '|';