Skip to content
Fix Code Error

PostgreSQL: Which version of PostgreSQL am I running?

March 13, 2021 by Code Error
Posted By: Anonymous

I’m in a corporate environment (running Debian Linux) and didn’t install it myself. I access the databases using Navicat or phpPgAdmin (if that helps). I also don’t have shell access to the server running the database.

Solution

Run this query from PostgreSQL:

SELECT version();
Answered By: Anonymous

Related Articles

  • Homebrew install specific version of formula?
  • How to install the Raspberry Pi cross compiler on my…
  • SQL query return data from multiple tables
  • Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?
  • How to Update Database from Assets Folder in App
  • How can I get column names from a table in SQL Server?
  • How to get $HOME directory of different user in bash script?
  • How to thoroughly purge and reinstall postgresql on ubuntu?
  • How to permanently set $PATH on Linux/Unix?
  • Postgres could not connect to server
  • How can I start PostgreSQL server on Mac OS X?
  • Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  • Database development mistakes made by application developers
  • How do I install Java on Mac OSX allowing version switching?
  • Problems with local variable scope. How to solve it?
  • Can Windows Containers be hosted on linux?
  • Get operating system info
  • PostgreSQL column 'foo' does not exist
  • Cannot install packages using node package manager in Ubuntu
  • How do I obtain a Query Execution Plan in SQL Server?
  • How to mount host volumes into docker containers in…
  • CentOS 64 bit bad ELF interpreter
  • Why cat does not work with parameter -0 in xargs?
  • debuild - Is it possible to build several debian…
  • Start redis-server with config file
  • What are the calling conventions for UNIX &…
  • Debugging the error "gcc: error:…
  • PostgreSQL database default location on Linux
  • How to remove MySQL completely with config and…
  • How to determine the current shell I'm working on
  • how to integrate selenium driver for chrome and…
  • Error using GraphQL Fragments with Apollo Hooks
  • how to log in to mysql and query the database from…
  • Psql could not connect to server: No such file or…
  • How do I query using fields inside the new…
  • I want to create a SQLite database like in the…
  • Runing vue/cli app under docker simple index.html is opened
  • Possible to perform cross-database queries with PostgreSQL?
  • Actual meaning of 'shell=True' in subprocess
  • Maven: add a dependency to a jar by relative path
  • Best way to select random rows PostgreSQL
  • Improve INSERT-per-second performance of SQLite
  • How to use multiple databases in Laravel
  • configure: error: C compiler cannot create executables
  • What are the steps of running a Java Swing…
  • Passport.js in Next.js app not saving user across…
  • How to use an existing database with an Android application
  • How to UPSERT (MERGE, INSERT ... ON DUPLICATE…
  • Aurelia bundling issue with virtual directory
  • SQL Client for Mac OS X that works with MS SQL Server
  • Setting Django up to use MySQL
  • How to use pipenv on mac?
  • How to turn off ALL conventions in Entity Framework Core 5
  • How/When does Execute Shell mark a build as failure…
  • JavaFX and OpenJDK
  • Can not connect to local PostgreSQL
  • Shell script to set environment variables
  • What's a concise way to check that environment…
  • How can "SELECT 1 + 1" :: IO [Only Int] be of type…
  • How to install pip with Python 3?
  • C++ IDE for Linux?
  • How should I deal with "package '✘✘✘' is not…
  • Best practice multi language website
  • How do I deal with installing peer dependencies in…
  • ERROR 1698 (28000): Access denied for user…
  • Ubuntu: OpenJDK 8 - Unable to locate package
  • How to connect to a docker container from outside…
  • Efficient SQL test query or validation query that…
  • how to customize `show processlist` in mysql?
  • Running shell command and capturing the output
  • Can a shell script set environment variables of the…
  • Virtual Memory Usage from Java under Linux, too much…
  • Why does an SSH remote command get fewer environment…
  • How to return result of a SELECT inside a function…
  • Query for array elements inside JSON type
  • fe_sendauth: no password supplied
  • How to restart Postgresql
  • Backup/Restore a dockerized PostgreSQL database
  • Error installing PyPI xmlsec==1.3.3 Python2
  • How to Delete previous database snapshot using regex?
  • PostgreSQL Crosstab Query
  • PG::ConnectionBad - could not connect to server:…
  • How to upgrade PostgreSQL from version 9.6 to…
  • Parse Android Room Generated Schema to Actual SQLite Script
  • How to solve error "Missing `secret_key_base` for…
  • postgresql port confusion 5433 or 5432?
  • Difference between rake db:migrate db:reset and…
  • How do I connect to this localhost from another…
  • useEffect Error: Minified React error #321 (GTM…
  • sql query to find priority jobs
  • How to create a temporary table in SSIS control flow…
  • Union of multiple Database queries with same parameters
  • Run a PostgreSQL .sql file using command line arguments
  • How to speed up insertion performance in PostgreSQL
  • How to Allow Remote Access to PostgreSQL database
  • PostgreSQL return result set as JSON array?
  • How to update Python?
  • How to install scala 2.12
  • Set environment variables on Mac OS X Lion
  • Interrupt an earlier timeout event in Simpy

Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.

Post navigation

Previous Post:

Run a PostgreSQL .sql file using command line arguments

Next Post:

What’s the difference between “Array()” and “[]” while declaring a JavaScript array?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

.net ajax android angular arrays aurelia backbone.js bash c++ css dataframe ember-data ember.js excel git html ios java javascript jquery json laravel linux list mysql next.js node.js pandas php polymer polymer-1.0 python python-3.x r reactjs regex sql sql-server string svelte typescript vue-component vue.js vuejs2 vuetify.js

  • you shouldn’t need to use z-index
  • No column in target database, but getting “The schema update is terminating because data loss might occur”
  • Angular – expected call-signature: ‘changePassword’ to have a typedeftslint(typedef)
  • trying to implement NativeAdFactory imports deprecated method by default in flutter java project
  • What should I use to get an attribute out of my foreign table in Laravel?
© 2022 Fix Code Error