PostgreSQL 7.4 Manual Example

Each one of the 592 HTML files in the PostgreSQL manual is a row in the postgresql_manual table.

psql ts_db < postgresql_manual.sql

psql ts_db

\d postgresql_manual;

ts_db=# \d postgresql_manual
	Table "public.postgresql_manual"
	Column  |       Type        | Modifiers
---------+-------------------+-----------
	file    | text              | not null
	title   | character varying |
	chapter | integer           |
	body    | character varying |
	ts_vec  | tsvector          |
Indexes:
	"postgresql_manual_file_pk" primary key, btree (file)
	"postgresql_manual_body_in" gist (ts_vec)
Triggers:
	ts_vec_update BEFORE INSERT OR UPDATE ON postgresql_manual 
	FOR EACH ROW EXECUTE PROCEDURE tsearch2('ts_vec', 'body')