Update PostgreSQL to 14.3
Summary: Release notes can be found here.
Test Plan:
- Import and query the Pagila sample database:
psql postgres -c "CREATE DATABASE pagila;"
psql pagila < pagila-schema.sql
psql pagila < pagila-data.sql
psql pagila -c "SELECT title, description FROM film WHERE fulltext @@ to_tsquery('saga&india');"- Connect to database using LibreOffice Base.
- Connect to database using Psycopg2:
python3
import psycopg2
conn = psycopg2.connect("dbname=pagila")
cur = conn.cursor()
cur.execute("SELECT title, description FROM film WHERE fulltext @@ to_tsquery('saga&india');")
for i in cur.fetchall():
print(f"Title: {i[0]}, description: {i[1]}")Reviewers: Triage Team, algent
Reviewed By: Triage Team, algent
Subscribers: algent
Differential Revision: https://dev.getsol.us/D13224