PostgreSQL: interval to number of days

select extract(epoch from my_interval)/86400;

Postgresql: import export of data

Export

copy (select * from shared_db.dt_process where process_name = 'AM_PARTITION') to '/tmp/shared_db__dt_process.csv' delimiter ',' csv header;

Import

copy shared_db.dt_process from '/tmp/shared_db__dt_process.csv';

CentOS: install Oracle JDK

• Download JDK from download.oracle.com

• cd /usr/local/share
  tar xvfz /media/host/jdk-8u60-linux-x64.tar.gz
  ln -s jdk1.8.0_60 jdk

• alternatives --install /usr/bin/java java /usr/local/share/jdk/bin/java 1
  alternatives --install /usr/bin/javac javac /usr/local/share/jdk/bin/javac 1
  alternatives --install /usr/bin/jar jar /usr/local/share/jdk/bin/jar 1