The main table definition SQL adds these tables:
- pgbench_branches:
CREATE TABLE pgbench_branches(bid int not null, bbalance int, filler char(88)); ALTER TABLE pgbench_branches add primary key (bid);
- pgbench_tellers:
CREATE TABLE pgbench_tellers(tid int not null,bid int, tbalance int,filler char(84)); ALTER TABLE pgbench_tellers add primary key (tid);
- pgbench_accounts:
CREATE TABLE pgbench_accounts(aid int not null,bid int, abalance int,filler char(84)); ALTER TABLE pgbench_accounts add primary key (aid);
- pgbench_history:
CREATE TABLE pgbench_history(tid int,bid int,aid int,delta int, mtime timestamp,filler char(22));
Before PostgreSQL 8.4, these tables did not have the pgbench_ prefix in their names. This was ...