mirror of
https://github.com/supabase/supabase.git
synced 2026-06-12 00:01:19 +08:00
## I have read the [CONTRIBUTING.md](https://github.com/supabase/supabase/blob/master/CONTRIBUTING.md) file. YES ## What kind of change does this PR introduce? Updates verbiage throughout docs to use postgres over postgresql. <!-- This is an auto-generated comment: release notes by coderabbit.ai --> ## Summary by CodeRabbit * **Documentation** * Updated terminology throughout documentation, guides, and resources for consistent product naming across all user-facing materials, including page titles, descriptions, and reference documentation. <!-- end of auto-generated comment: release notes by coderabbit.ai -->
23 lines
933 B
Plaintext
23 lines
933 B
Plaintext
---
|
|
title: 'Print Postgres version'
|
|
description: 'Useful snippet for finding out which version of postgres you are running'
|
|
footerHelpType: 'postgres'
|
|
---
|
|
|
|
It's important to know which version of Postgres you are running as each major version has different features and may cause breaking changes. You may also need to update your schema when [upgrading](https://www.postgresql.org/docs/current/pgupgrade.html) or downgrading to a major Postgres version.
|
|
|
|
Run the following query using the [SQL Editor](/dashboard/project/_/sql) in the Supabase Dashboard:
|
|
|
|
```sql
|
|
select
|
|
version();
|
|
```
|
|
|
|
Which should return something like:
|
|
|
|
```sql
|
|
PostgreSQL 15.1 on aarch64-unknown-linux-gnu, compiled by gcc (Ubuntu 10.3.0-1ubuntu1~20.04) 10.3.0, 64-bit
|
|
```
|
|
|
|
This query can also be executed via `psql` or any other query editor if you prefer to [connect directly to the database](/docs/guides/database/connecting-to-postgres#direct-connections).
|