# linux

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