postgres-showcase

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

Rollout

For running all the scripts on a local Postgres DB (superuser assumed) use the provided rollout.sh script which consist of:

ls *.sql | sort -n | xargs -n 1 psql -f

All feedback welcome!

Name		Name	Last commit message	Last commit date
Latest commit History 33 Commits
.gitattributes		.gitattributes
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_1_table_partitioning_range.sql		07_1_table_partitioning_range.sql
07_2_table_partitioning_hash.sql		07_2_table_partitioning_hash.sql
07_3_table_partitioning_list.sql		07_3_table_partitioning_list.sql
07_4_table_partitioning_multi_level.sql		07_4_table_partitioning_multi_level.sql
08_alter_table.sql		08_alter_table.sql
09_data_type_showcase.sql		09_data_type_showcase.sql
10_constraints.sql		10_constraints.sql
14_views.sql		14_views.sql
15_materialized_views.sql		15_materialized_views.sql
20_stored_functions.sql		20_stored_functions.sql
21_stored_procedures.sql		21_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_extensions.sql		45_extensions.sql
50_row_level_security.sql		50_row_level_security.sql
60_transaction_management.sql		60_transaction_management.sql
61_terminating_queries.sql		61_terminating_queries.sql
70_basic_analytics.sql		70_basic_analytics.sql
75_parallel_query_execution.sql		75_parallel_query_execution.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
rollout.sh		rollout.sh
todo.txt		todo.txt

License

cybertec-postgresql/postgres-showcase

Folders and files

Latest commit

History

Repository files navigation

postgres-showcase

Rollout

About

Topics

Resources

License

Stars

Watchers

Forks