Release notes can be found here and here.
Note that the update instructions need to be updated first, see help-center-docs#303.
Details
Details
- Reviewers
JoshStrobl - Group Reviewers
Triage Team - Commits
- R2469:55444a08264c: Update PostgreSQL to 14.1
- 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
Lint Not Applicable - Unit
Tests Not Applicable