Warning: is_dir(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/data/web/virtuals/98151/virtual) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php on line 465

Warning: Cannot modify header information - headers already sent by (output started at /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php:465) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/disable-xml-rpc-pingback/disable-xml-rpc-pingback.php on line 51
psql Archives - PostgreSQL Candies

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...