sql/export.sql

   1 SET SCHEMA B;
   2
   3 * *ALL_QUOTED = true
   4 * *DSV_COL_DELIM = ,
   5
   6 -- ExplanationNote: can't find a way to make it overwrite existing files,
   7 -- hence using \xq
   8 --PERFORM EXPORT DATA FROM TABLE "Produit" TO 'data/Produit.dsv;ignore_first=false;all_quoted=true';
   9
  10 * *DSV_TARGET_FILE = data/Produit.csv
  11 \xq SELECT * FROM "Produit"
  12 * *DSV_TARGET_FILE = data/Ingrédient.csv
  13 \xq SELECT * FROM "Ingrédient"
  14 * *DSV_TARGET_FILE = data/Lieu.csv
  15 \xq SELECT * FROM "Lieu"
  16 * *DSV_TARGET_FILE = data/Client.csv
  17 \xq SELECT * FROM "Client"
  18 * *DSV_TARGET_FILE = data/Période.csv
  19 \xq SELECT * FROM "Période"
  20 * *DSV_TARGET_FILE = data/Abonnement.csv
  21 \xq SELECT * FROM "Abonnement"
  22 * *DSV_TARGET_FILE = data/Facture.csv
  23 \xq SELECT * FROM "Facture"
  24 * *DSV_TARGET_FILE = data/Panier.csv
  25 \xq SELECT * FROM "Panier"
  26 * *DSV_TARGET_FILE = data/Vente.csv
  27 \xq SELECT * FROM "Vente"