This repository was archived by the owner on Oct 11, 2024. It is now read-only.

cybertec-postgresql/postgres-showcasePublic archive

NotificationsYou must be signed in to change notification settings
Fork37
Star167

Postgres features showcase (commented SQL samples) for beginners

License

BSD-3-Clause license

167 stars 37 forks Branches Tags Activity

Star

Notifications

You must be signed in to change notification settings

Branches Tags

Folders and files

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

Repository files navigation

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!

About

Postgres features showcase (commented SQL samples) for beginners

Releases

No releases published

Packages

No packages published

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

License

Uh oh!

Folders and files

Latest commit

History

Repository files navigation

postgres-showcase

Rollout

About

Topics

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages

Uh oh!

Contributors4

Uh oh!

Movatterモバイル変換

License

cybertec-postgresql/postgres-showcase

Folders and files

Latest commit

History

Repository files navigation

postgres-showcase

Rollout

About

Topics

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages0

Uh oh!

Contributors4

Uh oh!

Packages