pg_dump -Ft -U cmdi -h 192.168.1.1 -p 5432 -f file.tar database
select column1, array_to_string(array_agg(distinct column2),',') from table group by 1
Last updated 2 years ago