htbudget=# \d transaction Table "public.transaction" Column | Type | Modifiers ---------------+-----------------------------+---------------------------------------------------------- id | bigint | not null default nextval('transaction_id_seq'::regclass) balanced | boolean | not null default false note | text | date_transfer | date | not null date_value | date | amount | numeric(10,2) | not null balance | numeric(10,2) | not null description | text | category | text | date_import | timestamp without time zone | not null default now() Indexes: "pktransaction" PRIMARY KEY, btree (id)