Skip to content

Instantly share code, notes, and snippets.

@lettergram

lettergram/alter-table-add-index.sqp

Created July 8, 2018 03:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lettergram/b97d6f5fa0de3dd678414cda494b05d8 to your computer and use it in GitHub Desktop.
Save lettergram/b97d6f5fa0de3dd678414cda494b05d8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
alter-table-add-index.sqp
ALTER TABLE comments ADD COLUMN tsv_comment_text tsvector;
CREATE INDEX tsv_comment_text_idx ON comments USING gin(tsv_comment_text);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment