Farshid's Weblog

Posts tagged “postgresql”

  1. Granting a PostgreSQL user read-only access to some tables (2025-04-27)
  2. Embedding paragraphs from my blog with E5-large-v2 (2025-04-06)
  3. Closest locations to a point (2025-03-16)
  4. Upgrade Postgres.app on macOS (2024-12-01)
  5. Show the SQL schema for a PostgreSQL database (2024-02-24)
  6. Using unnest() to use a comma-separated string as the input to an IN query (2024-01-13)
  7. Constructing GeoJSON in PostgreSQL (2023-12-24)
  8. Enabling a gin index for faster LIKE queries (2023-10-01)
  9. Using json_extract_path in PostgreSQL (2023-09-09)
  10. Allowing a container in Docker Desktop for Mac to talk to a PostgreSQL server on the host machine (2023-02-25)