keystroke to clear screen in psql?
As an alternative to Ctrl-L use, e.g. for scripts in an linux environment: \! clear or \! cls for Microsoft.
psql
How to show data in a table by using psql command line interface?
Newer versions: (from 8.4 – mentioned in release notes) TABLE mytablename; Longer but works on all versions: SELECT * FROM mytablename; You may wish to use \x first if it’s a wide table, for readability. For long data: SELECT * FROM mytable LIMIT 10; or similar. For wide data (big rows), in the psql command … Read more