schema.txt

                                                   Table "public.posts"
 Column  |       Type        |                     Modifiers                      | Storage  | Stats target | Description
---------+-------------------+----------------------------------------------------+----------+--------------+-------------
 id      | integer           | not null default nextval('posts_id_seq'::regclass) | plain    |              |
 user_id | integer           | not null                                           | plain    |              |
 title   | character varying | not null                                           | extended |              |
 body    | text              |                                                    | extended |              |
Indexes:
    "posts_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "posts_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id)

[local] sean@db_driver_benchmarks=# \d+ users
                                                    Table "public.users"
   Column   |       Type        |                     Modifiers                      | Storage  | Stats target | Description
------------+-------------------+----------------------------------------------------+----------+--------------+-------------
 id         | integer           | not null default nextval('users_id_seq'::regclass) | plain    |              |
 name       | character varying | not null                                           | extended |              |
 hair_color | character varying |                                                    | extended |              |
Indexes:
    "users_pkey" PRIMARY KEY, btree (id)
Referenced by:
    TABLE "posts" CONSTRAINT "posts_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id)