How to find operating system (OS) that PostgreSQL server runs on

This query returns information on operating system PostgreSQL database runs on.

Query

select version();

Columns

  • version - information about PostgreSQL version and operating system version

Rows

Query returns just one row

Sample results