Printing PostgreSQL server version in PSQL console

Oct 22, 2024

Login to your PSQL console and connect to database

psql -h host -U username -d database

Run command to show version

SHOW server_version;

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

Written by tech kamar

No responses yet

Write a response

What are your thoughts?

Also publish to my profile

Recommended from Medium

Middleware for PostgreSQL: Is It Feasible or a Maintenance Nightmare?

Mr.PlanB

Middleware for PostgreSQL: Is It Feasible or a Maintenance Nightmare?

PostgreSQL, one of the most versatile and powerful relational databases, offers a wide range of features for managing data. Its…

Jan 4

Postgres Security 101: Logging and Auditing (3/8)

Oz

Postgres Security 101: Logging and Auditing (3/8)

Logging and auditing are critical components of any robust security strategy for PostgreSQL. Proper logging enables database administrators…

Oct 4, 2024

Lists

Staff picks

827 stories1648 saves

Stories to Help You Level-Up at Work

19 stories948 saves

Self-Improvement 101

20 stories3355 saves

Productivity 101

20 stories2818 saves

How to Migrate from Oracle to PostgreSQL Using Ora2Pg: Step-by-Step Tutorial

Sheikh Wasiu Al Hasib

How to Migrate from Oracle to PostgreSQL Using Ora2Pg: Step-by-Step Tutorial

Ora2Pg is an open-source tool designed to migrate Oracle databases to PostgreSQL. It automates the process of converting Oracle database…

Nov 20, 2024

Another way to Optimize MySQL Queries from 190 Seconds to 1 Second for Tens of Millions of Records

In

Towards Dev

by

Mike Chan

Another way to Optimize MySQL Queries from 190 Seconds to 1 Second for Tens of Millions of Records

Another solution to handle the performance issue in 1 second without the need to change the business nature of the SQL

Oct 21, 2024

Cron Jobs with PostgreSQL and the pg_cron extension

Tihomir Manushev

Cron Jobs with PostgreSQL and the pg_cron extension

plus Docker and Ubuntu

Mar 5

PostgreSQL table partitioning

In

DevOps.dev

by

Ashish Joshi

PostgreSQL table partitioning

Non-members can read the full article here.

Oct 16, 2024

See more recommendations

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams