COPY (SELECT lpad(cast(code_barre as varchar(13)), 13, '0') as "Product_id", b.reference as "Reference", b.libelle as "Libelle", (b.qte_reelle-qte_en_reserve) as "Quantity", b.prix_vente as "Price", b.prix_vente as "Price2" from article b where suppr='N' and b.code_barre is not null and b.pvpromo is not null and  b.qte_reelle-qte_en_reserve>0 and prix_vente>0 and libelle !='CHEQUE CADEAU' and pvpromo>0 order by "Quantity") TO 'C:/BRUMAN/ExtractArt_datejour.csv' DELIMITER ';' CSV;