Get to know pgadmin4 and postgreSQL

[janis-rullis]

http://pga.lm1.local/browser/

From Janis-Rullis-IT/flexi-tic-tac-toe#42

Tasks

• Temp priv Get to know pgadmin4 and postgreSQL #7 (comment)
• Seq. Get to know pgadmin4 and postgreSQL #7 (comment)
• Backup DB.
• Backup tab.
• Create tab.
• Tab comments.
• Try indexes.
• Explain and analyze.
• Monitor queries.
• Public user.
• Box columns https://www.postgresql.org/docs/13/release-13.html
• Incremental sorting.
• vacuuming.
• Maintenance
• Allow EXPLAIN, auto_explain, autovacuum, and pg_stat_statements to track WAL usage statistics
• read-only transaction mode
• streaming replication
• Allow FETCH FIRST to use WITH TIES to return any additional rows that match the last result row
• Add ALTER TABLE ... DROP EXPRESSION to allow removing the GENERATED property from a column
• Types. Add ALTER TYP
• JSON. Add alternate version of jsonb_set() wit
• NORMALIZE()
• Add function gen_random_uuid() to generate version-4 UUIDs
• Add function min_scale()
• Add function trim_scale()
• Generate backup manifests for base backups, and verify them.
• A new tool pg_verifybackup can verify backups.
• Have pg_basebackup estimate the total backup size by defau

[janis-rullis]

Temporary priv

• https://github.com/Janis-Rullis-IT/sql/blob/master/postgresql/Priveleges.md

[janis-rullis]

Seq.

• https://github.com/Janis-Rullis-IT/sql/blob/master/postgresql/Seq.md