Barman  : Backup and recovery manager for PostgreSQL (DB Query log Backup Program)

 

Barman

Allows your company to implement disaster recovery solutions for PostgreSQL databases with high requirements of business continuity.Taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee.Version 2.9 (1 Aug 2019)| Releas

www.pgbarman.org

 

CREATE TABLE measures (
    seq   SERIAL   CONSTRAINT firstkey PRIMARY KEY,
    key        varchar(40) not null ,
    values    varchar(200) not null,
    input_dt   date not null,
    extends  varchar(100) 
    
);

DROP TABLE P_TEST

select * from measures

insert into measures (key, values, input_dt, extends) values('TE' , '36.5℃', NOW(), '');
 

 

http://www.postgresql.org/docs/9.4/static/sql-insert.html

 

PostgreSQL: The world's most advanced open source database

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. There is a wealth of information to be found descr

www.postgresql.org

 

반응형

+ Recent posts