Use the command line switch option -e to input the query and > to redirect the output to a file:
Best results in other decks
Postgres supports multiple built-in range datatypes: int4range int8range numrange tsrange (range with timestamp without timezone) tstzrange (range with timestamp...
Performing COUNT(*) on large tables is slow. Sometimes you don’t need the exact number once results exceed a certain...