alexklibisz

-- Export Transactions from Firefly-III Database
-- This query produces a reasonable CSV export of transactions from a Firefly-III database.
-- Adjust the user_id if you have multiple users.
-- Tested on Postgres.
select cast(tj.date as date) as date,
       tj.description as description,
       round(tcredit.amount, 2) as credit_amount,
       acredit.name as credit_account,
       round(tdebit.amount, 2) as debit_amount,
       adebit.name as debit_account,