[PostgreSQL] PostgreSQL / PPAS 기본 쿼리

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

Barman

 

• PostgreSQL http://www.postgresql.org
• Barman : http://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