Release notes can be found here.
Details
Details
- Reviewers
Staudey - Group Reviewers
Triage Team - Commits
- R2469:caae9a8e37f4: Update PostgreSQL to 14.4
- 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]}")Diff Detail
Diff Detail
- Repository
- R2469 postgresql
- Lint
Automatic diff as part of commit; lint not applicable. - Unit
Automatic diff as part of commit; unit tests not applicable.