meta data for this page

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
software:postgresql [2021/09/25 22:51] christiansoftware:postgresql [2024/02/26 21:31] christian
Line 1: Line 1:
 ====== PostgreSQL and PostGIS ====== ====== PostgreSQL and PostGIS ======
- 
  
   * [[software:postgresql:pg9|PostgreSQL9]]   * [[software:postgresql:pg9|PostgreSQL9]]
Line 8: Line 7:
  
 ===== Tips and snippets ===== ===== 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/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'''