Dataset pour maarch

[USRA]

svp est ce que je peux trouver un dataset pour remplir maarch courrier 17.06

[HZZ]

svp, pouvez vous être plus clair?! que voulez vous faire exactement?

[USRA]

je veux faire insertion minimum de 1000 lignes dans la table res_letterbox pour faire une analyse et je cherche s’il ya un dataset deja existante ou bien une methode pour faire insertion facilement et rapidement

[HZZ]

Non, ceci n’existe pas . à vous de créer votre propre fichier d’insertion

[florian.azizian]

Bonjour,

voici une structure pour faire une boucle de 1000 itérations. Vous avez juste à remplacer “REQUETE SQL” par la requête que vous souhaitez :

do $$
begin
for r in 1…1000 loop
REQUETE SQL
end loop;
end;
$$;

[USRA]

Svp je sais pas comment écrire la requête prière de m’aider
voici la définition de la table res_letterbox

CREATE TABLE public.res_letterbox
(
res_id bigint NOT NULL DEFAULT nextval(‘res_id_mlb_seq’::regclass),
title character varying(255) DEFAULT NULL::character varying,
subject text,
description text,
publisher character varying(255) DEFAULT NULL::character varying,
contributor character varying(255) DEFAULT NULL::character varying,
type_id bigint NOT NULL,
format character varying(50) NOT NULL,
typist character varying(128) NOT NULL,
creation_date timestamp without time zone NOT NULL,
modification_date timestamp without time zone DEFAULT now(),
fulltext_result character varying(10) DEFAULT NULL::character varying,
ocr_result character varying(10) DEFAULT NULL::character varying,
converter_result character varying(10) DEFAULT NULL::character varying,
author character varying(255) DEFAULT NULL::character varying,
author_name text,
identifier character varying(255) DEFAULT NULL::character varying,
source character varying(255) DEFAULT NULL::character varying,
doc_language character varying(50) DEFAULT NULL::character varying,
relation bigint,
coverage character varying(255) DEFAULT NULL::character varying,
doc_date timestamp without time zone,
docserver_id character varying(32) NOT NULL,
folders_system_id bigint,
arbox_id character varying(32) DEFAULT NULL::character varying,
path character varying(255) DEFAULT NULL::character varying,
filename character varying(255) DEFAULT NULL::character varying,
offset_doc character varying(255) DEFAULT NULL::character varying,
logical_adr character varying(255) DEFAULT NULL::character varying,
fingerprint character varying(255) DEFAULT NULL::character varying,
filesize bigint,
is_paper character(1) DEFAULT NULL::bpchar,
page_count integer,
scan_date timestamp without time zone,
scan_user character varying(50) DEFAULT NULL::character varying,
scan_location character varying(255) DEFAULT NULL::character varying,
scan_wkstation character varying(255) DEFAULT NULL::character varying,
scan_batch character varying(50) DEFAULT NULL::character varying,
burn_batch character varying(50) DEFAULT NULL::character varying,
scan_postmark character varying(50) DEFAULT NULL::character varying,
envelop_id bigint,
status character varying(10) NOT NULL,
destination character varying(50) DEFAULT NULL::character varying,
approver character varying(50) DEFAULT NULL::character varying,
validation_date timestamp without time zone,
work_batch bigint,
origin character varying(50) DEFAULT NULL::character varying,
is_ingoing character(1) DEFAULT NULL::bpchar,
priority smallint,
arbatch_id bigint,
policy_id character varying(32) DEFAULT NULL::character varying,
cycle_id character varying(32) DEFAULT NULL::character varying,
cycle_date timestamp without time zone,
is_multi_docservers character(1) NOT NULL DEFAULT ‘N’::bpchar,
is_frozen character(1) NOT NULL DEFAULT ‘N’::bpchar,
custom_t1 text,
custom_n1 bigint,
custom_f1 numeric,
custom_d1 timestamp without time zone,
custom_t2 character varying(255) DEFAULT NULL::character varying,
custom_n2 bigint,
custom_f2 numeric,
custom_d2 timestamp without time zone,
custom_t3 character varying(255) DEFAULT NULL::character varying,
custom_n3 bigint,
custom_f3 numeric,
custom_d3 timestamp without time zone,
custom_t4 character varying(255) DEFAULT NULL::character varying,
custom_n4 bigint,
custom_f4 numeric,
custom_d4 timestamp without time zone,
custom_t5 character varying(255) DEFAULT NULL::character varying,
custom_n5 bigint,
custom_f5 numeric,
custom_d5 timestamp without time zone,
custom_t6 text DEFAULT NULL::character varying,
custom_d6 timestamp without time zone,
custom_t7 character varying(255) DEFAULT NULL::character varying,
custom_d7 timestamp without time zone,
custom_t8 character varying(255) DEFAULT NULL::character varying,
custom_d8 timestamp without time zone,
custom_t9 character varying(255) DEFAULT NULL::character varying,
custom_d9 timestamp without time zone,
custom_t10 character varying(255) DEFAULT NULL::character varying,
custom_d10 timestamp without time zone,
custom_t11 character varying(255) DEFAULT NULL::character varying,
custom_t12 character varying(255) DEFAULT NULL::character varying,
custom_t13 character varying(255) DEFAULT NULL::character varying,
custom_t14 character varying(255) DEFAULT NULL::character varying,
custom_t15 character varying(255) DEFAULT NULL::character varying,
reference_number character varying(255) DEFAULT NULL::character varying,
tablename character varying(32) DEFAULT ‘res_letterbox’::character varying,
initiator character varying(50) DEFAULT NULL::character varying,
dest_user character varying(128) DEFAULT NULL::character varying,
video_batch integer,
video_time integer,
video_user character varying(128) DEFAULT NULL::character varying,
video_date timestamp without time zone,
esign_proof_id character varying(255),
esign_proof_content text,
esign_content text,
esign_date timestamp without time zone,
locker_user_id character varying(255) DEFAULT NULL::character varying,
locker_time timestamp without time zone,
confidentiality character(1),
tnl_path character varying(255) DEFAULT NULL::character varying,
tnl_filename character varying(255) DEFAULT NULL::character varying,
CONSTRAINT res_letterbox_pkey PRIMARY KEY (res_id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.res_letterbox
OWNER TO postgres;