DEV Community

Paul Lefebvre
Paul Lefebvre

Posted on

2 2

Quick Tip: Get PostgreSQL version

I ran into this the other day and thought it might be worth a quick tip. I had a need to figure out what version of PostgreSQL was running on a server. It turns out you can easily get this information with a quick database query:

SELECT version();
Enter fullscreen mode Exit fullscreen mode

I hope this helps someone.

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay