> For the complete documentation index, see [llms.txt](https://ploegert.gitbook.io/til/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://ploegert.gitbook.io/til/programmy/linux.md).

# linux

- [Limit Execution Time Of Statements](https://ploegert.gitbook.io/til/programmy/linux/limit-execution-time-of-statements.md)
- [Install Postgres With uuid-ossp Using asdf](https://ploegert.gitbook.io/til/programmy/linux/install-postgres-with-uuid-ossp-using-asdf.md)
- [Find The Location Of Postgres Config Files](https://ploegert.gitbook.io/til/programmy/linux/find-the-location-of-postgres-config-files.md)
- [Find The Data Directory](https://ploegert.gitbook.io/til/programmy/linux/find-the-data-directory.md)
- [Create hstore From Two Arrays](https://ploegert.gitbook.io/til/programmy/linux/create-hstore-from-two-arrays.md)
- [Insert Just The Defaults](https://ploegert.gitbook.io/til/programmy/linux/insert-just-the-defaults.md)
- [Stop a Service](https://ploegert.gitbook.io/til/programmy/linux/stop-a-service.md)
- [Is App Installed?](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed.md)
- [Change The Current Directory For psql](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/change-the-current-directory-for-psql.md)
- [Check If The Local Server Is Running](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/check-if-the-local-server-is-running.md)
- [connections](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/connections.md)
- [Connect To An RDS PostgreSQL Database](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/connections/connect-to-an-rds-postgresql-database.md)
- [Terminating A Connection](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/connections/terminating-a-connection.md)
- [List Connections To A Database](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/connections/list-connections-to-a-database.md)
- [Force SSL When Making A psql Connection](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/connections/force-ssl-when-making-a-psql-connection.md)
- [Crypto](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/crypto.md)
- [Salt And Hash A Password With pgcrypto](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/crypto/salt-and-hash-a-password-with-pgcrypto.md)
- [Set A Seed For The Random Number Generator](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/crypto/set-a-seed-for-the-random-number-generator.md)
- [Generating UUIDs With pgcrypto](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/crypto/generating-uuids-with-pgcrypto.md)
- [Compute The md5 Hash Of A String](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/crypto/compute-the-md5-hash-of-a-string.md)
- [Compute Hashes With pgcrypto](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/crypto/compute-hashes-with-pgcrypto.md)
- [Database Operations](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/database-operations.md)
- [List Database Objects With Disk Usage](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/database-operations/list-database-objects-with-disk-usage.md)
- [List All The Databases](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/database-operations/list-all-the-databases.md)
- [Get The Size Of A Database](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/database-operations/get-the-size-of-a-database.md)
- [Dump All Databases To A SQL File](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/database-operations/dump-all-databases-to-a-sql-file.md)
- [Duplicate A Local Database](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/database-operations/duplicate-a-local-database.md)
- [Dump And Restore A Database](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/database-operations/dump-and-restore-a-database.md)
- [Create Database Uses Template1](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/database-operations/create-database-uses-template1.md)
- [DateTime Operations](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/datetime-operations.md)
- [Timestamp Functions](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/datetime-operations/timestamp-functions.md)
- [Using Intervals To Offset Time](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/datetime-operations/using-intervals-to-offset-time.md)
- [Turning Timing On](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/datetime-operations/turn-timing-on.md)
- [Intervals Of Time By Week](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/datetime-operations/intervals-of-time-by-week.md)
- [Convert A String To A Timestamp](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/datetime-operations/convert-a-string-to-a-timestamp.md)
- [Day Of Week For A Date](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/datetime-operations/day-of-week-for-a-date.md)
- [Determining The Age Of Things](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/datetime-operations/determining-the-age-of-things.md)
- [Day Of Week By Name For A Date](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/datetime-operations/day-of-week-by-name-for-a-date.md)
- [Constructing A Range Of Dates](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/datetime-operations/constructing-a-range-of-dates.md)
- [Configure The Timezone](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/datetime-operations/configure-the-timezone.md)
- [Functions](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/functions.md)
- [List All Versions Of A Function](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/functions/list-all-versions-of-a-function.md)
- [Group By The Result Of A Function Call](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/functions/group-by-the-result-of-a-function-call.md)
- [Edit Existing Functions](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/functions/edit-existing-functions.md)
- [File Operations](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/file-operations.md)
- [Extracting Nested JSON Data](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/file-operations/extracting-nested-json-data.md)
- [Export Query Results To A CSV](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/file-operations/export-query-results-to-a-csv.md)
- [IDE/Display](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/ide-display.md)
- [Auto Expanded Display](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/ide-display/auto-expanded-display.md)
- [Clear The Screen In psql](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/ide-display/clear-the-screen-in-psql.md)
- [Clear The Screen In psql (2)](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/ide-display/clear-the-screen-in-psql-2.md)
- [Indexing](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/indexing.md)
- [Use Argument Indexes](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/indexing/use-argument-indexes.md)
- [Using Expressions In Indexes](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/indexing/using-expressions-in-indexes.md)
- [Adding Composite Uniqueness Constraints](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/indexing/adding-composite-uniqueness-constraints.md)
- [Add Foreign Key Constraint Without A Full Lock](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/indexing/add-foreign-key-constraint-without-a-full-lock.md)
- [Create A Composite Primary Key](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/indexing/create-a-composite-primary-key.md)
- [Create An Index Without Locking The Table](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/indexing/create-an-index-without-locking-the-table.md)
- [Add ON DELETE CASCADE To Foreign Key Constraint](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/indexing/add-on-delete-cascade-to-foreign-key-constraint.md)
- [Math Operations](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/math-operations.md)
- [Two Ways To Compute Factorial](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/math-operations/two-ways-to-compute-factorial.md)
- [Integers In Postgres](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/math-operations/integers-in-postgres.md)
- [Generate Series Of Numbers](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/math-operations/generate-series-of-numbers.md)
- [Count The Number Of Trues In An Aggregate Query](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/math-operations/count-the-number-of-trues-in-an-aggregate-query.md)
- [Count Records By Type](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/math-operations/count-records-by-type.md)
- [Count How Many Records There Are Of Each Type](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/math-operations/count-how-many-records-there-are-of-each-type.md)
- [Assumed Radius Of The Earth](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/math-operations/assumed-radius-of-the-earth.md)
- [Compute The Levenshtein Distance Of Two Strings](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/math-operations/compute-the-levenshtein-distance-of-two-strings.md)
- [Queries](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries.md)
- [Write A Query Result To File](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/write-a-query-result-to-file.md)
- [Union All Rows Including Duplicates](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/union-all-rows-including-duplicates.md)
- [Truncate All Rows](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/truncate-all-rows.md)
- [Use Not Valid To Immediately Enforce A Constraint](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/use-not-valid-to-immediately-enforce-a-constraint.md)
- [Storing Emails With citext](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/storing-emails-with-citext.md)
- [Print The Query Buffer In psql](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/print-the-query-buffer-in-psql.md)
- [Prevent A Query From Running Too Long](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/prevent-a-query-from-running-too-long.md)
- [Insert A Bunch Of Records With Generate Series](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/insert-a-bunch-of-records-with-generate-series.md)
- [Find Records That Have Multiple Associated Records](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/find-records-that-have-multiple-associated-records.md)
- [Find Records That Contain Duplicate Values](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/find-records-that-contain-duplicate-values.md)
- [Between Symmetric](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/between-symmetric.md)
- [Difference Between Explain And Explain Analyze](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/difference-between-explain-and-explain-analyze.md)
- [Creating Conditional Constraints](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/creating-conditional-constraints.md)
- [Aggregate A Column Into An Array](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/aggregate-a-column-into-an-array.md)
- [Schema](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/schema.md)
- [pg Prefix Is Reserved For System Schemas](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/schema/pg-prefix-is-reserved-for-system-schemas.md)
- [List All Columns Of A Specific Type](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/schema/list-all-columns-of-a-specific-type.md)
- [Default Schema](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/schema/default-schema.md)
- [Sequence](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/sequence.md)
- [Restart A Sequence](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/sequence/restart-a-sequence.md)
- [Renaming A Sequence](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/sequence/renaming-a-sequence.md)
- [List Available Schemas](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/sequence/list-available-schemas.md)
- [String Operations](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/string-operations.md)
- [Two Ways To Escape A Quote In A String](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/string-operations/two-ways-to-escape-a-quote-in-a-string.md)
- [Word Count for a Column](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/string-operations/word-count-for-a-column.md)
- [String Contains Another String](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/string-operations/string-contains-another-string.md)
- [Pretty Printing JSONB Rows](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/string-operations/pretty-printing-jsonb-rows.md)
- [Pretty Print Data Sizes](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/string-operations/pretty-print-data-sizes.md)
- [Escaping String Literals With Dollar Quoting](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/string-operations/escaping-string-literals-with-dollar-quoting.md)
- [Escaping A Quote In A String](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/string-operations/escaping-a-quote-in-a-string.md)
- [Capitalize All The Words](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/string-operations/capitalize-all-the-words.md)
- [A Better Null Display Character](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/string-operations/a-better-null-display-character.md)
- [Table Operations](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/table-operations.md)
- [Restarting Sequences When Truncating Tables](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/table-operations/restarting-sequences-when-truncating-tables.md)
- [Temporary Tables](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/table-operations/temporary-tables.md)
- [Renaming A Table](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/table-operations/renaming-a-table.md)
- [Truncate Tables With Dependents](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/table-operations/truncate-tables-with-dependents.md)
- [List All Rows In A Table](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/table-operations/list-all-rows-in-a-table.md)
- [Get The Size Of A Table](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/table-operations/get-the-size-of-a-table.md)
- [Get A Quick Approximate Count Of A Table](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/table-operations/get-a-quick-approximate-count-of-a-table.md)
- [Fizzbuzz With Common Table Expressions](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/table-operations/fizzbuzz-with-common-table-expressions.md)
- [Find Duplicate Records In Table Without Unique Id](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/table-operations/find-duplicate-records-in-table-without-unique-id.md)
- [Create Table Adds A Data Type](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/table-operations/create-table-adds-a-data-type.md)
- [Check Table For Any Oprhaned Records](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/table-operations/check-table-for-any-orphaned-records.md)
- [Types & Operators](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators.md)
- [Special Math Operators](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/special-math-operators.md)
- [The nullif Function](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/the-nullif-function.md)
- [Types By Category](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/types-by-category.md)
- [Shorthand Absolute Value Operator](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/shorthand-absolute-value-operator.md)
- [Show All Versions Of An Operator](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/show-all-versions-of-an-operator.md)
- [Switch Non-Castable Column Type With Using Clause](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/switch-non-castable-column-type-with-using-clause.md)
- [Remove Not Null Constraint From A Column](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/remove-not-null-constraint-from-a-column.md)
- [List Various Kinds Of Objects](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/list-various-kinds-of-objects.md)
- [Max Identifier Length Is 63 Bytes](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/max-identifier-length-is-63-bytes.md)
- [Lower Is Faster Than ilike](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/lower-is-faster-than-ilike.md)
- [Is It Null Or Not Null?](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/is-it-null-or-not-null.md)
- [Getting A Slice Of An Array](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/getting-a-slice-of-an-array.md)
- [Get The Size Of An Index](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/get-the-size-of-an-index.md)
- [Generate A UUID](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/generate-a-uuid.md)
- [Generate Random UUIDs Without An Extension](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/generate-random-uuids-without-an-extension.md)
- [Determine Types Of JSONB Records](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/determine-types-of-jsonb-records.md)
- [Defining Arrays](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/defining-arrays.md)
- [Creating Custom Types](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/creating-custom-types.md)
- [Checking The Type Of A Value](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/checking-the-type-of-a-value.md)
- [Checking Inequality](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/types-and-operators/checking-inequality.md)
- [User Operations](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/user-operations.md)
- [Who Is The Current User](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/user-operations/who-is-the-current-user.md)
- [List Database Users](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/user-operations/list-database-users.md)
- [pgbouncer](https://ploegert.gitbook.io/til/programmy/linux/pgbouncer.md)
- [Backup Databse](https://ploegert.gitbook.io/til/programmy/linux/pgbouncer/backup-databse.md)
- [pgbouncer](https://ploegert.gitbook.io/til/programmy/linux/pgbouncer/pgbouncer.md)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://ploegert.gitbook.io/til/programmy/linux.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.