postgresqlHow do I get the version of PostgreSQL installed on my system?
The version of PostgreSQL installed on your system can be obtained by using the psql command.
psql --versionOutput example
psql (PostgreSQL) 10.12The psql command is used to connect to a PostgreSQL database, and it also provides several options to obtain information about the PostgreSQL installation. The --version option prints the version of the PostgreSQL server.
The version of PostgreSQL can also be obtained by using the SELECT version() statement.
SELECT version();Output example
PostgreSQL 10.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bitThe SELECT version() statement returns the version of the PostgreSQL server, the operating system, and the compiler used to build the server.
To summarize, the version of PostgreSQL installed on your system can be obtained by using the psql --version command or the SELECT version() statement.
Helpful links
More of Postgresql
- How do I use PostgreSQL's XMLTABLE to parse XML data?
- How can I retrieve data from PostgreSQL for yesterday's date?
- How do I use PostgreSQL's XMIN and XMAX features?
- How do I use the PostgreSQL quote_ident function?
- How do I round a number in PostgreSQL?
- How do I use the PostgreSQL NVL function?
- How do I use PostgreSQL with Qt?
- How can I use PostgreSQL XOR to compare two values?
- How do I use the WITH statement in PostgreSQL?
- How can I decide between PostgreSQL and MySQL for my software development project?
See more codes...