Patrick

Patrick has asked 9 questions and find answers to 180 problems.

Stats

About

Building PostgreSQL-based application for tropical forest information management.

Patrick questions

Reviewing defined row level security policies in PostgreSQL-9.5
How can I efficiently find the index of a value in a sorted array?
Retrieving all object privileges for specific role
Referencing current row in FILTER clause of window function

Patrick answers

How to list all columns with it's reference in postgresql like in mysql?
PostgreSQL ORDER BY clause on numerical portion of text column [duplicate]
Select * from table where column.id is not in the other table's column1 OR column2? PostgreSQL
Create index on calculated value
Check if a value can be typecast as an interval in postgres
In PostgreSQL, I want a before insert trigger to dynamically change blanks into valid UUIDs
createdb: too many command line arguments (first is template0)
PostgreSQL UPDATE FROM
querying JSONB with array fields
How to replace substring in Postgres