PostgreSQL disable more output

by

To disable pagination but retain the output, use:

\pset pager off

To remember this setting, add it to your ~/.psqlrc, e.g. like this: echo \\pset pager off >> ~/.psqlrc

See the psql manual.

On older versions of Pg it was just a toggle, so \pset pager

To completely suppress query output, use \o /dev/null in your psql script.

To suppress psql‘s informational output, run it with -q or set QUIET=1 in the environment.

To produce results and throw them away you can redirect stdout to /dev/null with:

psql db -f sql.sql >/dev/null

You can redirect both stdout and stderr with:

psql db -f sql.sql >&/dev/null

but I don’t recommend that, as it’ll throw away error information that might warn you something isn’t going right. You’re also producing results and throwing them away, which is inefficient; you’re better off just not producing them in the first place by adjusting your queries.

More Related Contents:

  1. PostgreSQL “DESCRIBE TABLE”
  2. How to exit from PostgreSQL command line utility: psql
  3. In psql, why do some commands have no effect?
  4. How do I specify a password to ‘psql’ non-interactively?
  5. Run batch file with psql command without password
  6. Run a PostgreSQL .sql file using command line arguments
  7. How to switch databases in psql?
  8. Postgresql: Scripting psql execution with password
  9. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  10. psql: FATAL: database “” does not exist
  11. PostgreSQL: Why psql can’t connect to server?
  12. Use variable set by psql meta-command inside of DO block
  13. Alternate output format for psql showing one column per line with column name
  14. Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib
  15. Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy
  16. PostgreSQL LIKE query performance variations
  17. How to import CSV file data into a PostgreSQL table
  18. The forgotten assignment operator “=” and the commonplace “:=”
  19. Equivalent to unpivot() in PostgreSQL
  20. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  21. I forgot the password I entered during postgres installation
  22. How do I do large non-blocking updates in PostgreSQL?
  23. How to configure PostgreSQL to accept all incoming connections
  24. Disable PostgreSQL foreign key checks for migrations
  25. Spark Dataframes UPSERT to Postgres Table
  26. Using row_to_json() with nested joins
  27. pgAdmin III Why query results are shortened?
  28. How do I handle opening/closing Db connection in a Go app?
  29. What’s the difference between pg_table_size, pg_relation_size & pg_total_relation_size? (PostgreSQL)
  30. JPA and PostgreSQL with GenerationType.IDENTITY

Leave a Comment