Copy data between 2 postgres dbs

# 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 '|';

psql copy docu

postgres sql copy docu

About me

Hi, i'm Premysl Donat and this is a place where i share things i find interesting.

This is my picture:

Premysl Donat at Balaton lake

I'm a web developer and i work at UOL. I also have a tiny company named Imagine Anything under which i run few side projects. Imagine has a beautiful logo so you better check it out!

I release all of my code under MIT license and it's freely available at Github.

Have a good one, Premek

Follow @Masa331