-- Table: public.tmp_metrics_for_upload

-- DROP TABLE public.tmp_metrics_for_upload;

CREATE TABLE public.tmp_metrics_for_upload
(
  nzp_cr integer,
  nzp_kvar integer,
  num_ls integer,
  nzp_serv integer,
  nzp_cnttype integer,
  num_cnt character varying(40),
  dat_prov date,
  dat_provnext date,
  dat_uchet date,
  val_cnt double precision,
  norma double precision,
  is_actual integer,
  nzp_user integer,
  dat_when date,
  dat_close date,
  cur_unl integer,
  nzp_wp integer,
  ist integer,
  dat_oblom date,
  dat_poch date,
  dat_del date,
  user_del integer,
  nzp_counter integer,
  month_calc date,
  dat_d date,
  dat_po date,
  dat_block timestamp without time zone,
  user_block integer,
  pkod numeric(13,0),
  service character(100),
  val_cnt_max double precision
)
WITH (
  OIDS=TRUE
);
ALTER TABLE public.tmp_metrics_for_upload
  OWNER TO admin;

-- Index: public.nzp_counter_tmp_metrics_for_upload

-- DROP INDEX public.nzp_counter_tmp_metrics_for_upload;

CREATE INDEX nzp_counter_tmp_metrics_for_upload
  ON public.tmp_metrics_for_upload
  USING btree
  (nzp_counter);

-- Index: public.nzp_cr_tmp_metrics_for_upload

-- DROP INDEX public.nzp_cr_tmp_metrics_for_upload;

CREATE INDEX nzp_cr_tmp_metrics_for_upload
  ON public.tmp_metrics_for_upload
  USING btree
  (nzp_cr);

\copy public.tmp_metrics_for_upload To 'D:\test.csv' With CSV HEADER