Which version of PostgreSQL am I running? 3 ways to check
Stuck wondering which PostgreSQL version you're running? Learn three quick methods—psql, SQL query, and pg_config—to check your version and avoid compatibility issues.
Tag archive
Stuck wondering which PostgreSQL version you're running? Learn three quick methods—psql, SQL query, and pg_config—to check your version and avoid compatibility issues.
There is no DESCRIBE TABLE in PostgreSQL — run \d table_name in psql, or query information_schema.columns from any SQL client, including Supabase.
Exit psql with \q (any version), exit or quit (PostgreSQL 11+), or Ctrl+D. Plus how to escape a paused pager, a stuck quote, and Windows quirks.
psql command not found = PostgreSQL client not installed, or not on PATH. Install via brew/apt/choco/scoop, or add the bin directory to PATH.
Drop every table in PostgreSQL without dropping the database: schema reset, DO-block loop, and the guards that keep you off production.
Switch databases in psql with \c — plus why USE database fails in Postgres, connection-string switching, and multi-database workflows.
PostgreSQL has no SHOW TABLES. Use \dt in psql or information_schema.tables in Supabase. Every method, plus why your query returns zero rows.
Today I needed to group records by a substring contents of one of the columns. We have data like...
Every application stores data somewhere, and for most web applications, that means a relational...

Our application runs on the production server smoothly. But we don't have any test/QA environment...

Have you been looking for the ideal database for your applications? The most frequent SQL options to...
Repo postgresql-persistent-connect This docker containerized server is up and running in seconds. ...