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…
- 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.