postgres-showcase

Sample object creation and query scripts to illustrate different Postgres object types and data quering possibilities. Targeted for beginners.

Rollout with psql:

ls -1 *.sql | sort -V | xargs cat | psql

All feeback welcome!

Name		Name	Last commit message	Last commit date
Latest commit History 9 Commits
00_create_database.sql		00_create_database.sql
01_create_role.sql		01_create_role.sql
02_create_schema.sql		02_create_schema.sql
02_search_path.sql		02_search_path.sql
03_make_public_schema_secure.sql		03_make_public_schema_secure.sql
04_alter_role.sql		04_alter_role.sql
05_create_table.sql		05_create_table.sql
06_create_table_options.sql		06_create_table_options.sql
07_alter_table.sql		07_alter_table.sql
09_data_type_showcase.sql		09_data_type_showcase.sql
10_views.sql		10_views.sql
15_materialized_views.sql		15_materialized_views.sql
20_stored_procedures.sql		20_stored_procedures.sql
25_table_using_sproc.sql		25_table_using_sproc.sql
30_simple_trigger.sql		30_simple_trigger.sql
32_event_trigger.sql		32_event_trigger.sql
40_custom_types.sql		40_custom_types.sql
41_enum_types.sql		41_enum_types.sql
45_domains.sql		45_domains.sql
50_row_level_security.sql		50_row_level_security.sql
60_transaction_management.sql		60_transaction_management.sql
70_basic_analytics.sql		70_basic_analytics.sql
80_advanced_indexing.sql		80_advanced_indexing.sql
81_string_processing.sql		81_string_processing.sql
82_arrays.sql		82_arrays.sql
LICENSE		LICENSE
README.md		README.md
psql_basics.md		psql_basics.md
python_connectivity.py		python_connectivity.py
todo.txt		todo.txt

Provide feedback