SELECT * FROM speech WHERE speech_tsv @@ plainto_tsquery('a text string')

Table "public.speech"
    Column     |            Type             |                      Modifiers
---------------+-----------------------------+-----------------------------------------------------
 speech_id     | integer                     | not null default nextval('speech_id_seq'::regclass)
 speechtype_id | smallint                    | not null
 title         | character varying           | not null default ''::character varying
 speechdate    | date                        | default now()
 location      | character varying           | not null default ''::character varying
 source        | character varying           | not null default ''::character varying
 speechtext    | text                        | not null
 url           | character varying           | not null default ''::character varying
 release_id    | smallint                    |
 created       | timestamp without time zone |
 modified      | timestamp without time zone |
 speech_tsv    | tsvector                    |
 key           | boolean                     |
 summary       | text                        |
 quote         | text                        |
Indexes:
    "speech_pk" PRIMARY KEY, btree (speech_id)
    "speech__release_id" btree (release_id)
    "speech__speech_tsv" gin (speech_tsv)
    "speech__speechdate" btree (speechdate)
    "speech__speechtype_id" btree (speechtype_id)