klt
/
addressVault
1
0
Fork 0
Code Issues 3 Pull Requests 0 Projects 0 Releases 0 Wiki Activity
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.
9 Commits
1 Branch
176 KiB
 
 
 
Branch: main
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'main'
${ noResults }
 ZIP  TAR.GZ
Nikolaus Thiel ce9e6fbacf README: psql command corrected 2 weeks ago
0_dbPreparation.sql first version, still things to improve 2 months ago
1_adressen.sql bug fix: an invalid address must not be in result set 2 weeks ago
2_hub_land.sql first version, still things to improve 2 months ago
3_hub_region.sql first version, still things to improve 2 months ago
4_hub_ort.sql first version, still things to improve 2 months ago
LICENSE Initial commit 2 months ago
README.md README: psql command corrected 2 weeks ago
extractDDL.zsh first version, still things to improve 2 months 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');"