Skip to content

Instantly share code, notes, and snippets.

@knmkr

knmkr/is_postgres_greater_equal_9_3.sh

Last active August 29, 2015 14:20
Show Gist options
  • Save knmkr/78bd221c2c5e20673c0d to your computer and use it in GitHub Desktop.
Save knmkr/78bd221c2c5e20673c0d to your computer and use it in GitHub Desktop.
Download ZIP
Check if PostgreSQL version > 9.3
Raw
is_postgres_greater_equal_9_3.sh
$ psql $dbname $username --tuples-only -c "SELECT substring(version() from 'PostgreSQL (\d\.\d)')::float >= 9.3"| tr -d ' '
t
@knmkr
Copy link
Author

knmkr commented May 8, 2015

SHOW server_version_num を使った方が良さそう：

$ psql -tc "SHOW server_version"
 9.4.1

$ psql -tc "SHOW server_version_num"
 90401

$ test $(psql -tc "SHOW server_version_num") -ge 90300
$ echo $?
0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment