Barman : Backup and recovery manager for PostgreSQL (DB Query log Backup Program)
- 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
반응형