postgresql full text search schema

postgres_fts.sql

ALTER TABLE my_table ADD COLUMN tsdoc tsvector;
CREATE INDEX my_table_tsvec_idx ON my_table USING GIN (customer_id, tsdoc);

-- Full text search for datafield specs
CREATE FUNCTION my_table_tsvec_trigger() RETURNS trigger AS $$  
BEGIN
  NEW.tsdoc :=
    setweight(to_tsvector('simple', coalesce(NEW.name,'')), 'A') ||
    setweight(to_tsvector('simple', coalesce(NEW.description,'')), 'B');
  return NEW;
END
$$ LANGUAGE plpgsql;

CREATE TRIGGER my_table_tsvec_update BEFORE INSERT OR UPDATE
  ON my_table FOR EACH ROW EXECUTE PROCEDURE my_table_tsvec_trigger();