Pinned Loading

1. note-functions note-functions Public

   Learn In Public: Zsh functions to create and display files stored in a configurable "notes" directory.

   Shell 2

2. Install postgres pagila (DVD rental)... Install postgres pagila (DVD rental) database

   1

   ## Install pagila in local postgres db

   2

   3

   *These directions assume postgres is installed locally with a user—preferably not a superuser—with the same name as your OS username.*

   4

   5

   From the shell:

3. pgtab pgtab Public

   Learning in Public: PostgreSQL database for JSON Tabular Data Packages

   PLpgSQL 1

4. PostgreSQL PL/pgSQL procedure: crea... PostgreSQL PL/pgSQL procedure: creates staging table of numbered, text columns (f1, f2, f3…)

   1

   CREATE PROCEDURE create_text_table (fields INT, tablename TEXT = '_import')

   2

   AS $$

   3

   /*

   4

   DESCRIPTION       create text-only staging table

   5

     ARGUMENTS       fields: number of fields (columns)

5. Summary of SUMMARY OF LESS COMMANDS Summary of SUMMARY OF LESS COMMANDS

   1

              Summary of SUMMARY OF LESS COMMANDS

   2

   3

    -<letter>            Toggle a command line option [see OPTIONS below].

   4

    <number>             Set N by entering number before command.

   5