Skip to content

sys_version

Edgar Fuste edited this page Nov 2, 2021 · 1 revision

Description:

System table with data about all the software version updates.

Fields:

Column name Data type Description Example
id serial Id 1
giswater character varying(16) Giswater version 3.4.019
project_type character varying(16) Project type WS
postgres character varying(512) Postgres version PostgreSQL 9.5.17, compiled by Visual C++ build 1800, 64-bit
postgis character varying(512) Postgis version 2.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
date timestamp(6) Date of last giswater version update 2020-08-05 11:12:12.679667
language character varying(50) Project's language EN
epsg integer SRID of project's geometry 25831
sample boolean If true, project has giswater sample dataset TRUE
Clone this wiki locally