↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / Text Search Functions And Operators

tsvector_to_array

Read the PG 18 manual

Converts a tsvector to an array of lexemes.

Reading PG 18current·documented in 12 of 27 versions, 9.6 to 20

Signatures & examples

tsvector_to_array ( tsvector ) → text[]
Converts a tsvector to an array of lexemes.
tsvector_to_array('fat:2,4 cat:3 rat:5A'::tsvector) → {cat,fat,rat}
Version history 2
  1. 12 → 13 changed
  2. 9.5 → 9.6 added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source