Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+====== PostgreSQL and PostGIS ======
+  * [[software:postgresql:pg9|PostgreSQL9]]
+  * [[software:postgresql:pg12|PostgreSQL12]]
+  * [[software:postgresql:pgsql-u7|Postgresql+PostGIS on Uberspace U7]]
+===== Tips and snippets =====
+  * [[https://stackoverflow.com/questions/30272328/is-there-a-way-to-set-the-max-width-of-a-column-when-displaying-query-results-in|Display output from a query formatted to terminal width]] (via StackOverflow): ''\pset columns X'', "Be sure, so your pager is well configured - set global variables:" ''export PAGER=less'' ''export LESS='-iMSx4 -RSFX -e'''
+  * [[https://stackoverflow.com/questions/11188756/how-to-find-the-size-of-an-array-in-postgresql#30139522| StackOverflow: Test the length of an array in PostgreSQL]] using ''cardinality()'' e.g. ''SELECT a,b,c FROM mytable WHERE cardinality(myarray) > 2''