psql Tips

The \H or \html metacommand will turn on the HTML query output format.

laetitia=# \H
Output format is html.
laetitia=# select *
laetitia-# from test
laetitia-# where id = 1;

  

    
id
    
value
  
  

    
1
    
bla
  

(1 row)

This feature is available since at least Postgres 7.1.