Install PostgreSQL 9.3 on PcBSD 10

It quite simple only with a few small surprises. pgAdmin you can install directly from AppCafe onmyPcBSD PostgreSQL was notpartofAppCafe so I have to use manual install: as root: pkg install postgresql93-server output from installation will show you: to start...

Export data into CSV format

Command “COPY” will do all the dirty job.   Attention – examples are ment for Linux and contain variables which you have to set or substitute with values.   If data are small you will probably use directly unpacked form: psql -U postgres -d...