SET SCHEMA B;

* *ALL_QUOTED = true
* *DSV_COL_DELIM = |

-- ExplanationNote: can't find a way to make it overwrite existing files,
-- hence using \xq
--PERFORM EXPORT DATA FROM TABLE "Produit" TO 'data/Produit.dsv;ignore_first=false;all_quoted=true';

* *DSV_TARGET_FILE = data/Produit.csv
\xq SELECT * FROM "Produit"
* *DSV_TARGET_FILE = data/Ingrédient.csv
\xq SELECT * FROM "Ingrédient"
* *DSV_TARGET_FILE = data/Lieu.csv
\xq SELECT * FROM "Lieu"
* *DSV_TARGET_FILE = data/Client.csv
\xq SELECT * FROM "Client"
* *DSV_TARGET_FILE = data/Période.csv
\xq SELECT * FROM "Période"
* *DSV_TARGET_FILE = data/Abonnement.csv
\xq SELECT * FROM "Abonnement"
* *DSV_TARGET_FILE = data/Facture.csv
\xq SELECT * FROM "Facture"
* *DSV_TARGET_FILE = data/Panier.csv
\xq SELECT * FROM "Panier"
* *DSV_TARGET_FILE = data/Vente.csv
\xq SELECT * FROM "Vente"
* *DSV_TARGET_FILE = data/Prix.csv
\xq SELECT * FROM "Prix"