New answers tagged

1

I would use schemas to manage the individual department objects. For example: CREATE SCHEMA elect_dept; CREATE SCHEMA water_dept; Store each department's objects in the appropriate schema and use roles to manage access, for example: CREATE ROLE elect_dept; ALTER ROLE elect_dept SET SEARCH_PATH TO elect_dept,water_dept,public; GRANT ...


0

The simple answer is: create table points ( p POINT not null); create table lines ( l LINE not null); Then inserts look like this: insert into points (p) values (POINT(1.2, 123.1)); insert into lines (l) values (LINE(POINT(1.2, 123.1), POINT(-5, -123))); You probably want to build indexes if you want to have some lookups on them. Also a primary key ...



Top 50 recent answers are included