Skip to content
Database

打印 Postgres 版本

了解你正在使用的 Postgres 版本很重要,因为每个主要版本都有不同的功能,并且可能会引起不兼容的变化。当你升级或降级到主要的 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 or downgrading to a major Postgres version.

在 Supabase 仪表板中使用 SQL 编辑器 运行以下查询:

🌐 Run the following query using the SQL Editor in the Supabase Dashboard:

1
select
2
version();

应该会返回类似这样的内容:

🌐 Which should return something like:

1
PostgreSQL 15.1 on aarch64-unknown-linux-gnu, compiled by gcc (Ubuntu 10.3.0-1ubuntu1~20.04) 10.3.0, 64-bit

如果你愿意直接连接到数据库,这个查询也可以通过 psql 或任何其他查询编辑器执行。

🌐 This query can also be executed via psql or any other query editor if you prefer to connect directly to the database.