Presidential Speeches

This is a demo of PostgreSQL's full-text search capabilities. It uses the websearch_to_tsquery() function, which converts user input to a tsquery value and allows additional user controls. For example, placing words in quotes allows for adjacency queries. A minus sign allows for exclusion of a word.

The database contains 79 speeches made by U.S. presidents to Congress from 1946 to 2021. Most are "State of the Union" speeches typically delivered at the beginning of the year.

Try a search or see a list of speeches.