Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table sig_collection
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
collection |
public.ltree |
|
|
|
|||
|
|
geom_text |
text |
|
|
|
|
|
|
|
geom |
public.geometry |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table sig_collection
Check Constraints
There are no check constraints for table sig_collection
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
collection |
|
Triggers
There are no triggers for table sig_collection
Rules
There are no rules for table sig_collection
Policies
There are no policies for table sig_collection
Referenced
There are no tables referenced by table sig_collection
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
651 |
Pages |
65 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.sig_collection (
collection public.ltree NOT NULL,
geom_text TEXT,
geom public.geometry,
CONSTRAINT sig_collection_pkey PRIMARY KEY(collection)
) ;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |