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.
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.
 
 
klt 5db3ffe1e9 Merge pull request 'getpid with 1 vorname and nachname' (#22) from issue-21_getpid into main 2 months ago
.gitignore git ignore added 8 months ago
0_dbPreparation.sql first version, still things to improve 1 year ago
1_adressen.sql getpid with 1 vorname and nachname 2 months ago
2_hub_land.sql function is called getregion instead of getRegion 2 months ago
3_hub_region.sql function is called getregion instead of getRegion 2 months ago
4_hub_ort.sql new cities 2 months ago
LICENSE Initial commit 1 year ago
README.md README: psql command corrected 1 year ago
extractDDL.zsh first version, still things to improve 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');"