keystroke to clear screen in psql?

psql postgresql-9.3
rferrisx picture rferrisx · Sep 26, 2014 · Viewed 27.8k times · Source

I want a shortcut key to clear the screen in my (Windows 7) psql console just like CTRL-l clears the screen in my R console. I am tired of typing '! cls'. Do I need to write a macro for this? I am running Postgres 9.35. '\r' resets the query buffer but does not clear the screen. Thanks in advance for your help, sorry if I have just missed something simple.

Answer

Hartmut P. picture Hartmut P. · Jul 23, 2015

As an alternative to Ctrl-L use, e.g. for scripts in an linux environment:

\! clear

or 

\! cls

for Microsoft.

Related questions

PostgreSQL Nested JSON Querying

On PostgreSQL 9.3.4, I have a JSON type column called "person" and the data stored in it is in the format {dogs: [{breed: <>, name: <>}, {breed: <>, name: <>}]}. I want to retrieve the breed of …

Read More
PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More
Run a PostgreSQL .sql file using command line arguments

I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my PostgreSQL database in order to add them to a table. The files are that large that it is impossible to …

Read More