You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
2 months ago | |
---|---|---|
.gitignore | 8 months ago | |
0_dbPreparation.sql | 1 year ago | |
1_adressen.sql | 2 months ago | |
2_hub_land.sql | 2 months ago | |
3_hub_region.sql | 2 months ago | |
4_hub_ort.sql | 2 months ago | |
LICENSE | 1 year ago | |
README.md | 1 year ago | |
extractDDL.zsh | 1 year ago |
README.md
addressVault
A data vault like db schema to hold your addresses. The schema contains functions to export to bbdb, vCard and a simple LaTeX birthday list.
Dependency
Created and developped under PostgreSQL 12. May work for older version as well. Needs a database without schema adressen.
Installation
Execute the following:
psql -d <db> -f 0_dbPreparation.sql -f 1_adressen.sql -f 2_hub_land.sql -f 3_hub_region.sql -f 4_hub_ort.sql
psql -d <db> -c "INSERT INTO adressen.hub_gruppe (gruppen_name, kommentar) VALUES('Geburtstag', 'members of this group will appear in view geburtstag');"