PostgreSQL is an advanced open-source relational database management system (RDBMS) known for its robustness, extensibility, and standards compliance. It supports a wide range of data types and advanced features such as transactions, foreign keys, and full-text search, making it suitable for both small and large-scale applications.
Supported versions
- PostgreSQL 13 and above
Default Hierarchy
How objects are presented in the left hierarchy. The folders are in yellow.
Object Types
Dawiso integrates from PostgreSQL:
Database
Maps to PostgreSQL Database object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| description | Scanned Description |
| oid | OID |
| datminmxid | Min Multixact ID |
| tablespace | Tablespace |
| owner | Owner |
| encoding | Encoding |
| datcollate | LC_COLLATE |
| datctype | LC_CTYPE |
| datistemplate | Is Template |
| datallowconn | Allow Connection |
| datconnlimit | Max Connections |
| datfrozenxid | Frozen XID |
Schema
Maps to PostgreSQL Schema object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| nspname | Name |
| description | Scanned Description |
| owner | Owner |
Function
Maps to PostgreSQL Function object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| proname | Name |
| description | Scanned Description |
| oid | OID |
| prosecdef | Is security Definer |
| proleakproof | Has No Side Effects |
| proisstrict | Returns Null on Nulls |
| proretset | Returns a Set |
| provolatile | Volatile |
| proparallel | Parallel |
| pronargs | Nr. of Arguments |
| pronargdefaults | Nr. of Arguments with Default |
| prorettype | Return Data Type |
| proargdefaults | Default Values |
| owner | Owner |
| probin | Additional Call Info |
| proconfig | Local Settings |
| proacl | Access Control List |
| schema | Schema |
| language | Language |
| definition | Definition |
| arguments | Arguments |
| procost | Est. Execution Cost |
| prorows | Est. Nr. of Result Rows |
| prokind | Type |
Procedure
Maps to PostgreSQL Procedure object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| proname | Name |
| description | Scanned Description |
| oid | OID |
| prosecdef | Is security Definer |
| proleakproof | Has No Side Effects |
| proisstrict | Returns Null on Nulls |
| proretset | Returns a Set |
| provolatile | Volatile |
| proparallel | Parallel |
| pronargs | Nr. of Arguments |
| pronargdefaults | Nr. of Arguments with Default |
| prorettype | Return Data Type |
| proargdefaults | Default Values |
| owner | Owner |
| probin | Additional Call Info |
| proconfig | Local Settings |
| proacl | Access Control List |
| schema | Schema |
| language | Language |
| definition | Definition |
| arguments | Arguments |
| procost | Est. Execution Cost |
| prorows | Est. Nr. of Result Rows |
| prokind | Type |
Table
Maps to PostgreSQL Table object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| tablename | Name |
| description | Scanned Description |
| schema | Schema |
| user_defined_type_name | User Defined Type Name |
| is_insertable_into | Is Insertable Into |
| is_typed | Is Typed |
| commit_action | Commit Action |
| owner | Owner |
| tablespace | Tablespace |
| hasindexes | Has Indexes |
| hasrules | Has Rules |
| hastriggers | Has Triggers |
| rowsecurity | Has Row Security |
| user_defined_type_catalog | User Defined Type Catalog |
| user_defined_type_schema | USer Defined Type Schema |
Table Column
Maps to PostgreSQL Table Column object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| column_name | Name |
| description | Scanned Description |
| schema | Schema |
| numeric_precision_radix | Numeric Precision Radix |
| numeric_scale | Numeric Scale |
| datetime_precision | Datetime Precision |
| interval_type | Interval Type |
| interval_precision | Interval Precision |
| collation_catalog | Collation Catalog |
| collation_schema | Collation Schema |
| collation_name | Collation Name |
| domain_catalog | Domain Catalog |
| domain_schema | Domain Schema |
| table | Table |
| domain_name | Domain Name |
| udt_catalog | UDT Catalog |
| udt_schema | UDT Schema |
| udt_name | UDT Name |
| maximum_cardinality | Maximum Cardinality |
| dtd_identifier | DTD Identifier |
| is_updatable | Is Updateable |
| ordinal_position | Position |
| column_default | Default |
| is_nullable | Is Nullable |
| data_type | Datatype |
| character_maximum_length | Character Max Length |
| character_octet_length | Character Octet Length |
| numeric_precision | Numeric Precision |
View
Maps to PostgreSQL View object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| viewname | Name |
| description | Scanned Description |
| owner | Owner |
| definition | Definition |
View Column
Maps to PostgreSQL View Column object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| column_name | Name |
| description | Scanned Description |
| schema | Schema |
| numeric_precision_radix | Numeric Precision Radix |
| numeric_scale | Numeric Scale |
| datetime_precision | Datetime Precision |
| interval_type | Interval Type |
| interval_precision | Interval Precision |
| collation_catalog | Collation Catalog |
| collation_schema | Collation Schema |
| collation_name | Collation Name |
| domain_catalog | Domain Catalog |
| domain_schema | Domain Schema |
| table | Table |
| domain_name | Domain Name |
| udt_catalog | UDT Catalog |
| udt_schema | UDT Schema |
| udt_name | UDT Name |
| maximum_cardinality | Maximum Cardinality |
| dtd_identifier | DTD Identifier |
| is_updatable | Is Updateable |
| ordinal_position | Position |
| column_default | Default |
| is_nullable | Is Nullable |
| data_type | Datatype |
| character_maximum_length | Character Max Length |
| character_octet_length | Character Octet Length |
| numeric_precision | Numeric Precision |