create_database.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

CREATE database shop;

CREATE EXTENSION postgis;
CREATE EXTENSION uint;

CREATE TYPE color AS (red uint1, green uint1, blue uint1);

CREATE TABLE shop_color (shop text, color color);

INSERT INTO shop_color(shop, color) VALUES
('Netto', (255, 238, 82)),
('365discount', (0, 170, 70)),
('Rema 1000', (0, 36, 88))
;