view schema/README.md @ 3003:92818da6133d

Cleanup VIEW definition NULLS LAST is not necessary on non-nullable columns; avoid materializing unused columns in a CTE; use boolean value directly instead of comparing to auto-casted string; gauge_measurements might contain not only waterlevels; avoid unnecessary subselects.
author Tom Gottfried <tom@intevation.de>
date Wed, 10 Apr 2019 18:50:20 +0200
parents 85c47d63fdb9
children f2f0b776ba12
line wrap: on
line source

The gemma database schema requires PostgreSQL >= 11.

`dot.tmpl` is a template file for `postgresql_autodoc`
to be more similiar to UML and leave out some less useful labels.

See  `../docker/README.md`