PostgreSQL: Which version of PostgreSQL am I running?
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…
- Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?
- SQL query return data from multiple tables
- How can I get column names from a table in SQL Server?
- How to thoroughly purge and reinstall postgresql on ubuntu?
- How to get $HOME directory of different user in bash script?
- How can I start PostgreSQL server on Mac OS X?
- Postgres could not connect to server
- How to permanently set $PATH on Linux/Unix?
- Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
- Database development mistakes made by application developers
- Problems with local variable scope. How to solve it?
- PostgreSQL column 'foo' does not exist
- Can Windows Containers be hosted on linux?
- Get operating system info
- How do I install Java on Mac OSX allowing version switching?
- Cannot install packages using node package manager in Ubuntu
- How to mount host volumes into docker containers in…
- How do I obtain a Query Execution Plan in SQL Server?
- CentOS 64 bit bad ELF interpreter
- PostgreSQL database default location on Linux
- How do I query using fields inside the new…
- What are the calling conventions for UNIX &…
- Psql could not connect to server: No such file or…
- Debugging the error "gcc: error:…
- Possible to perform cross-database queries with PostgreSQL?
- Error using GraphQL Fragments with Apollo Hooks
- Start redis-server with config file
- How to determine the current shell I'm working on
- How to UPSERT (MERGE, INSERT ... ON DUPLICATE…
- How to remove MySQL completely with config and…
- How to use multiple databases in Laravel
- Best way to select random rows PostgreSQL
- SQL Client for Mac OS X that works with MS SQL Server
- Actual meaning of 'shell=True' in subprocess
- how to log in to mysql and query the database from…
- Maven: add a dependency to a jar by relative path
- Improve INSERT-per-second performance of SQLite
- How to use an existing database with an Android application
- Aurelia bundling issue with virtual directory
- Setting Django up to use MySQL
- Runing vue/cli app under docker simple index.html is opened
- configure: error: C compiler cannot create executables
- What's a concise way to check that environment…
- How/When does Execute Shell mark a build as failure…
- Shell script to set environment variables
- ERROR 1698 (28000): Access denied for user…
- Can not connect to local PostgreSQL
- JavaFX and OpenJDK
- C++ IDE for Linux?
- Efficient SQL test query or validation query that…
- Backup/Restore a dockerized PostgreSQL database
- How to install pip with Python 3?
- Query for array elements inside JSON type
- Best practice multi language website
- Passport.js in Next.js app not saving user across…
- How to return result of a SELECT inside a function…
- How to restart Postgresql
- fe_sendauth: no password supplied
- Run a PostgreSQL .sql file using command line arguments
- PostgreSQL Crosstab Query
- how to customize `show processlist` in mysql?
- How to upgrade PostgreSQL from version 9.6 to…
- How to Allow Remote Access to PostgreSQL database
- Running shell command and capturing the output
- Why does an SSH remote command get fewer environment…
- Ubuntu: OpenJDK 8 - Unable to locate package
- Can a shell script set environment variables of the…
- postgresql port confusion 5433 or 5432?
- Difference between rake db:migrate db:reset and…
- How to speed up insertion performance in PostgreSQL
- How to connect to a docker container from outside…
- How do I deal with installing peer dependencies in…
- Virtual Memory Usage from Java under Linux, too much…
- How to get the PYTHONPATH in shell?
- useEffect Error: Minified React error #321 (GTM…
- PostgreSQL return result set as JSON array?
- PG::ConnectionBad - could not connect to server:…
- How should I deal with "package 'xxx' is not…
- How to solve error "Missing `secret_key_base` for…
- How do you connect to multiple MySQL databases on a…
- How to List All Redis Databases?
- How to create a temporary table in SSIS control flow…
- How can I access my localhost from my Android device?
- Set environment variables on Mac OS X Lion
- Pentaho Data Integration SQL connection
- How to create a new database after initally…
- Fatal error: Call to undefined function pg_connect()
- Can't find the 'libpq-fe.h header when trying to…
- How to concatenate strings of a string field in a…
- How to use shell commands in Makefile
- How to configure postgresql for the first time?
- How do I modify fields inside the new PostgreSQL…
- Select rows which are not present in other table
- postgres default timezone
- PostgreSQL database service
- Install pip in docker
- How do I connect to this localhost from another…
- Select Tag Helper in ASP.NET Core MVC
Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.
