Get a PostgreSQL servers version

psql -X -A -t -c "SELECT version();"

Without using a pipe. -X ignores the user's .psqlrc configuration file -A sets un-aligned table output mode -t prints rows only (no headers or footers)

Sample Output

PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.2 20140206 (prerelease), 64-bit

By: malathion

2014-05-01 18:10:20

bash Linux postgresql psql

2 Alternatives + Submit Alt

Get a PostgreSQL servers version

In a multiple PostgreSQL server environment knowing the servers version can be important. Note that psql --version returns just the local psql apps version which may not be what you want. This command dumps the PostgreSQL servers version out to one line. You may need to add more command line options to the psql command for your connection environment. Show Sample Output
This is sample output - yours may be different.
```
PostgreSQL 9.3.3 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.8.2 20131212 (Red Hat 4.8.2-7), 64-bit
```
0

psql -h <SERVER NAME HERE> -c 'SELECT version();' | grep -v 'version\|---\|row\|^ *$' | sed 's/^\s*//'

pnelsonsr · 2014-03-17 18:36:40 8
Get a PostgreSQL servers version

-t, --tuples-only print rows only Show Sample Output
This is sample output - yours may be different.
```
 PostgreSQL 9.2.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.7.2 20121109 (Red Hat 4.7.2-8), 64-bit
```
0

psql -h <SERVER NAME HERE> -t -c 'SELECT version();' |head -1

hxre · 2014-04-25 08:26:23 8

What Others Think

Exactly what i was searching and feeling peace to get this website. Good luck for next. https://www.jacketsjunction.com/category/brown-leather-jackets/

sherrinelson890 · 224 weeks and 2 days ago

where to get shrooms dried mushrooms african pyramid mushroom african transkei mushroom albino penis envy b+ mushrooms blue meanies mushroom brazilian magic mushroom burmese mushroom golden teacher mushroom ko samui super strain malabar coast martinique mexican mushroom mushroom british columbia super thai mushroom nepalese chitwan mushroom penis envy texas penis envy 6 texas yellow caps vietnamese white jedi mind fuck tri coloured ecuadorian mushroom magic mushsroom edibles mexican cubensis psychedelic chocolate bar where to get shrooms dried mushrooms african pyramid mushroom african transkei mushroom albino penis envy b+ mushrooms blue meanies mushroom brazilian magic mushroom burmese mushroom golden teacher mushroom ko samui super strain malabar coast martinique mexican mushroom mushroom british columbia super thai mushroom nepalese chitwan mushroom penis envy texas penis envy 6 texas yellow caps vietnamese white jedi mind fuck tri coloured ecuadorian mushroom magic mushsroom edibles mexican cubensis psychedelic chocolate bar midnight mint psychedelic chocolate bar origin mango psilo gummies 0.25g-1g origin strawberry psilo gummies 0.25g-1g penis envy psychedelic chocolate bar psilocybin cube gummies vegan dark chocolate psychedelic chocolate bar microdoses brain capsules 50mg-200mg chill capsules 50mg-200mg clarity capsules 50mg-200mg health capsules 50mg-200mg love capsules 50mg-200mg mood capsules 50mg-200mg pure capsules 50mg-200mg social capsules 30 pack 350mg social capsules 5 pack 350mg buy weed online without medical card marijuana flowers types of concentrates cannabis cartridges buy edibles online legal marijuana shatter cannabis wax marijuana hash buy psychedelic online tinctures for anxiety cannabis seeds bank weed smoker accessories birthday cake kush acdc strain ace killer og strain ak 47 strain alaskan thunder fuck alien kush strain ambrosia kush strain atomik moon rocks cbd 40.57% atomik moon rocks diamond 58.77% banana og strain bc big bud strain birthday cake kush blue cheese strain blue dream og kush blue moonrock kush blue rhino strain blueberry kush strain bruce banner strain cannabis trim cherry pie strain cannatonic strain citrix strain dark star kush durban poison strain eleven roses strain g13 haze strain gelato strain girl scout cookies flavors girl scout cookies online granddaddy purple grape nana strain grape pie strain green crack strain guava kush strain hawaiian skunk jack herer strain mendo breath weed mighty mango mr nice guy weed blue mystic strain northern lights strain northern lights moon rock platinum og kush gas og strain pink og kush platinum hawaiian strain pootie tang strain purple mimosa strain purple white widow strain smart buds sour diesel weed strain sour moonrock strain space monkey tins strawberry banana weed sun rocks super citrus haze strain super silver haze wedding cake strain exotic white widows strain zombie kush strain hybrid weed indica strains sativa strains moon rock for sale cookies sfhaightst alien labs garrison lane gashouse grandiflora insane jokes up lemonade parlay runtz alien labs biskante 3.5g alien labs kryptochronic preroll alien labs kryptochronic smalls 7.0g alien labs melonade x sherbacio livesauce 1.0g alien labs xeno 3.5g alien labs xeno 5 pack prerolls alien labs baklava preroll berry pie cannatique sweet tartz 3.5g cbd flower 8th bag carrot cake cbd flower 8th bag lemon drop cbd flower 8th bag monk fruit cookies cream cookies gary payton 20 3.5g cookies kings road 3.5g cookies london poundcake 3.5g cookies sunset sherbert 3.5g cookies sweet tea 3.5g fiore pomelo anderson 3.5g fiore cherry cream pie 3.5g fiore guava berry 3.5g galactic gas london chello georgia pie juiced suds 3.5g snow man summer lane strain grandi melon hectane strain pineapple piss lemonade project 4516 ya hemi cookies/a> yadada strain insane og strain insane mac eleven strain insane pound cake strain insane rockstar strain lucky charmz baby kiwi chiclet lemonade lemon cookies strain lemonnade lychee lemonnade medellin cookies lemonnade sorbet lemonnade tangeray lions mane strain ooh la la indoor pineapple piss lemonade yellow fruit stripes lemonade jetlato strain mia runtz potato runtz runtz rock devine runt hawaiian runtz live resin runtz og obama runtz white runtz hawaiian runtz moneybagg runtz pink runtz mia runtz potato runtz blue m&m strain cherry cherry lemonade cherry pie og x jack the ripper cosmic cookies strain cutton candy kush mint midnight cannabis oreo cookies rasberry lemonade sunset strain white chocolate trufflez strains wonderbrett black truffle strain dope house trufflez london truffle strain dessert truffle weed pirate truffles weed strain purple truffles strain snow white truffle strain truffle cake strain truffle pie strain beyond blueberry black orchid grapes of warth lemon oz kush melon og orange banana oz kush pineapple og pink picasso strawberry bliss wonderbrett chomp banana pound cake marujuana apple fritter strain banana lato marijuana forbidden fruit strain got bars og by synergy kiwi strawberry strain papaya marijuana strain fruity pebbles marijuana golden state banana peanut butter mochi super og stiiizy mochilato liiit 3.5g

johnson20007 · 148 weeks and 2 days ago

Amazing! This blog looks just like my old one! It's on a completely different subject but it has pretty much the same layout and design. Wonderful choice of colors! Pug Puppies for Sale Near Me PUG PUPPY FOR SALE NEAR ME PUG PUPPIES FOR SALE pug puppies for sale in kentucky Pug Puppies for Sale Under $500 Near Me pug puppies for sale in texas pugs puppies for sale teacup pugs for sale pug puppies for sale by owner pug puppies ohio

rahimhh21 · 120 weeks ago

Perfecthomepugs · 110 weeks and 1 day ago

liltommy · 72 weeks and 1 day ago

donperi1 · 64 weeks and 3 days ago

What do you think?

Any thoughts on this command? Does it work on your machine? Can you do the same thing with only 14 characters?

You must be signed in to comment.

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands

Similar Commands

Keep SSH tunnel open (PostgreSQL example)

open a seperate konsole tab and ssh to each of N servers (konsole 4.2+)

postgresql SQL to show count of ALL tables (relations) including relation-size

How to run a command on a list of remote servers read from a file

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

» all commands
» commands with 3 up-votes (commandlinefu3)
» commands with 10 up-votes (commandlinefu10)