summaryrefslogtreecommitdiff
path: root/verify/transactions.sql
blob: 1a01f6fa611ac954cc8f268579db213a6a84ba61 (about) (plain)
1
2
3
4
5
6
7
8
9
10
11
-- Verify photos:transactions on pg

BEGIN;

SET search_path to photos;

SELECT id, photo_id, is_income, category, amount, note, created_at, updated_at
  FROM transactions
 WHERE FALSE;

ROLLBACK;