Files

ack
ansible
astro
aws
brew
chrome
clojure
css
deno
devops
docker
drizzle
elixir
gatsby
git
github-actions
go
groq
heroku
html
http
inngest
internet
java
javascript
jj
jq
kitty
linux
llm
mac
mise
mongodb
mysql
neovim
netlify
next-auth
nextjs
phoenix
planetscale
pnpm
postgres
- a-better-null-display-character.md
- add-foreign-key-constraint-without-a-full-lock.md
- add-on-delete-cascade-to-foreign-key-constraint.md
- add-unique-constraint-using-existing-index.md
- adding-composite-uniqueness-constraints.md
- aggregate-a-column-into-an-array.md
- assumed-radius-of-the-earth.md
- auto-expanded-display.md
- between-symmetric.md
- capitalize-all-the-words.md
- change-the-current-directory-for-psql.md
- change-the-owner-of-a-sequence.md
- check-if-clusters-are-upgrade-compatible.md
- check-if-the-local-server-is-running.md
- check-if-user-role-exists-for-database.md
- check-table-for-any-orphaned-records.md
- checking-inequality.md
- checking-the-type-of-a-value.md
- clear-the-screen-in-psql-2.md
- clear-the-screen-in-psql.md
- compute-hashes-with-pgcrypto.md
- compute-the-levenshtein-distance-of-two-strings.md
- compute-the-md5-hash-of-a-string.md
- concatenate-strings-with-a-separator.md
- configure-the-timezone.md
- constructing-a-range-of-dates.md
- convert-a-string-to-a-timestamp.md
- count-how-many-records-there-are-of-each-type.md
- count-records-by-type.md
- count-the-number-of-items-in-an-array.md
- count-the-number-of-trues-in-an-aggregate-query.md
- create-a-cluster-in-a-specific-data-directory.md
- create-a-composite-primary-key.md
- create-a-table-from-the-structure-of-another.md
- create-an-index-across-two-columns.md
- create-an-index-without-locking-the-table.md
- create-and-execute-sql-statements-with-gexec.md
- create-database-uses-template1.md
- create-hstore-from-two-arrays.md
- create-table-adds-a-data-type.md
- creating-conditional-constraints.md
- creating-custom-types.md
- day-of-week-by-name-for-a-date.md
- day-of-week-for-a-date.md
- default-schema.md
- defining-arrays.md
- determine-types-of-jsonb-records.md
- determining-the-age-of-things.md
- difference-between-explain-and-explain-analyze.md
- different-ways-to-define-an-interval.md
- dump-all-databases-to-a-sql-file.md
- dump-and-restore-a-database.md
- dump-the-sql-needed-recreate-a-table.md
- duplicate-a-local-database.md
- edit-existing-functions.md
- enable-logging-of-database-activity.md
- enforce-uniqueness-on-column-expression.md
- escaping-a-quote-in-a-string.md
- escaping-string-literals-with-dollar-quoting.md
- export-query-results-to-a-csv.md
- extracting-nested-json-data.md
- fetch-data-from-an-endpoint-in-sql.md
- fetch-specific-number-of-results.md
- find-duplicate-records-in-table-without-unique-id.md
- find-records-that-contain-duplicate-values.md
- find-records-that-have-multiple-associated-records.md
- find-the-data-directory.md
- find-the-location-of-postgres-config-files.md
- fizzbuzz-with-common-table-expressions.md
- force-ssl-when-making-a-psql-connection.md
- generate-a-uuid.md
- generate-modern-primary-key-columns.md
- generate-random-alphanumeric-identifier.md
- generate-random-uuids-without-an-extension.md
- generate-series-of-numbers.md
- generating-uuids-with-pgcrypto.md
- get-a-quick-approximate-count-of-a-table.md
- get-row-count-for-most-recent-query.md
- get-the-size-of-a-database.md
- get-the-size-of-a-table.md
- get-the-size-of-an-index.md
- get-the-size-on-disk-of-an-index.md
- getting-a-slice-of-an-array.md
- group-by-the-result-of-a-function-call.md
- idempotent-inserts.md
- include-all-queries-in-the-log-file.md
- include-columns-in-a-covering-index.md
- include-multiple-tables-in-a-pg-dump.md
- insert-a-bunch-of-records-with-generate-series.md
- insert-just-the-defaults.md
- inspect-progress-of-long-running-create-index.md
- install-postgres-with-uuid-ossp-using-asdf.md
- integers-in-postgres.md
- intervals-of-time-by-week.md
- is-it-null-or-not-null.md
- label-dollar-quoted-strings-with-a-tag.md
- limit-execution-time-of-statements.md
- list-all-columns-of-a-specific-type.md
- list-all-rows-in-a-table.md
- list-all-the-databases.md
- list-all-versions-of-a-function.md
- list-available-schemas.md
- list-connections-to-a-database.md
- list-database-objects-with-disk-usage.md
- list-database-users.md
- list-databases-available-for-connecting.md
- list-various-kinds-of-objects.md
- lower-is-faster-than-ilike.md
- manage-major-versions-with-brew-and-direnv.md
- max-identifier-length-is-63-bytes.md
- open-heroku-database-in-postico-from-terminal.md
- output-explain-query-plan-in-different-formats.md
- pg-prefix-is-reserved-for-system-schemas.md
- postgres-does-not-support-unsigned-integers.md
- prepare-execute-and-deallocate-statements.md
- pretty-print-data-sizes.md
- pretty-printing-jsonb-rows.md
- prevent-a-query-from-running-too-long.md
- print-the-query-buffer-in-psql.md
- put-unique-constraint-on-generated-column.md
- remove-not-null-constraint-from-a-column.md
- renaming-a-sequence.md
- renaming-a-table.md
- restart-a-sequence.md
- restarting-sequences-when-truncating-tables.md
- salt-and-hash-a-password-with-pgcrypto.md
- send-a-command-to-psql.md
- set-a-seed-for-the-random-number-generator.md
- set-a-statement-timeout-threshold-for-a-session.md
- set-inclusion-with-hstore.md
- sets-with-the-values-command.md
- shorthand-absolute-value-operator.md
- show-all-versions-of-an-operator.md
- show-reconstructed-constraints-for-a-table.md
- show-the-hidden-queries-behind-backslash-commands.md
- sleeping.md
- special-math-operators.md
- storing-emails-with-citext.md
- string-contains-another-string.md
- survey-of-user-defined-ordering-of-records.md
- switch-non-castable-column-type-with-using-clause.md
- switch-the-running-postgres-server-version.md
- table-names-are-treated-as-lower-case-by-default.md
- temporarily-disable-triggers.md
- temporary-tables.md
- terminating-a-connection.md
- the-nullif-function.md
- timestamp-functions.md
- toggling-the-pager-in-psql.md
- track-psql-history-separately-per-database.md
- trim-leading-and-trailing-space-from-string.md
- truncate-all-rows.md
- truncate-tables-with-dependents.md
- turn-timing-on.md
- two-ways-to-compute-factorial.md
- two-ways-to-escape-a-quote-in-a-string.md
- types-by-category.md
- unable-to-infer-data-type-in-production.md
- union-all-rows-including-duplicates.md
- use-a-psqlrc-file-for-common-settings.md
- use-a-trigger-to-mirror-inserts-to-another-table.md
- use-argument-indexes.md
- use-not-valid-to-immediately-enforce-a-constraint.md
- use-rename-to-hot-swap-two-tables.md
- use-variables-in-an-anonymous-function.md
- using-expressions-in-indexes.md
- using-intervals-to-offset-time.md
- who-is-the-current-user.md
- word-count-for-a-column.md
- write-a-query-result-to-file.md
prisma
python
rails
react-testing-library
react
react_native
reason
remix
rspec
ruby
sed
shell
sqlite
streaming
tailwind
tmux
typescript
unix
vercel
vim
vscode
webpack
workflow
xstate
yaml
zod
zsh
.vimrc
CONTRIBUTING.md
LICENSE
README.md

clear-the-screen-in-psql-2.md

Include the actual file for the latest til

Apr 22, 2016

c49beb5 · Apr 22, 2016

Clear The Screen In psql (2)

In Clear The Screen In psql, I showed how you can shell out to the clear command as a way of clearing the screen in psql.

It turns out there is an even simpler way. Just hit CTRL-l.