Database Documentation

  

 

 

 

 

 

 

 

 

 

12/24/2007


Index

Database: postgres _ 3

Schemas _ 3

pg_toast _ 3

public _ 3

information_schema _ 3

Server: Server _ 3

Tablespaces _ 3

pg_default _ 3

pg_global _ 3

Logins _ 3

postgres _ 3

About _ 3


Database: postgres

Properties

Name: postgres 
Owner: postgres 
Encoding: SQL_ASCII 
Template:  
Allows connections:  
Max connections: unlimited 
Tablespace: pg_default 
Session config:  
Default schema:  
Comment:

Schemas

NameOwnerSystemComment
 pg_toast postgres  Reserved schema for TOAST tables 
 public postgres  Standard public schema 
 information_schema postgres   
Total: 3 schema(s)

See Also

List of databases

Schemas


Schema: pg_toast

Properties

Name: pg_toast 
Owner: postgres 
System:  
Comment: Reserved schema for TOAST tables 

Domains

NameComment
 domain1 test domain 
 rrr  
Total: 2 domain(s)

Tables

NameOwnerTablespaceComment
 pg_toast_10737 postgres   
 pg_toast_10742 postgres   
 pg_toast_10747 postgres   
 pg_toast_10752 postgres   
 pg_toast_10757 postgres   
 pg_toast_10762 postgres   
 pg_toast_10767 postgres   
 pg_toast_1255 postgres   
 pg_toast_1260 postgres pg_global  
 pg_toast_1262 postgres pg_global  
 pg_toast_2396 postgres pg_global  
 pg_toast_2604 postgres   
 pg_toast_2606 postgres   
 pg_toast_2609 postgres   
 pg_toast_2618 postgres   
 pg_toast_2619 postgres   
Total: 16 table(s)

Types

NameOwnerComment
 pg_toast_10737 postgres  
 pg_toast_10742 postgres  
 pg_toast_10747 postgres  
 pg_toast_10752 postgres  
 pg_toast_10757 postgres  
 pg_toast_10762 postgres  
 pg_toast_10767 postgres  
 pg_toast_1255 postgres  
 pg_toast_1260 postgres  
 pg_toast_1262 postgres  
 pg_toast_2396 postgres  
 pg_toast_2604 postgres  
 pg_toast_2606 postgres  
 pg_toast_2609 postgres  
 pg_toast_2618 postgres  
 pg_toast_2619 postgres  
Total: 16 type(s)

See Also

List of schemas

Domains


Domain: domain1

Properties

Name: domain1 
OID: 16449 
Owner: postgres 
Base type: bigint 
Default:
Check:  
Not Null:  
Comment: test domain 

SQL

See Also

List of domains


Domain: rrr

Properties

Name: rrr 
OID: 16450 
Owner: postgres 
Base type: integer 
Default: 34 
Check: CHECK ((VALUE > 33)) 
Not Null:  
Comment:  

SQL

See Also

List of domains


Tables


Table: pg_toast_10737

Properties

Name: pg_toast_10737 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_10737_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_10737_index

Properties

Name: pg_toast_10737_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_10742

Properties

Name: pg_toast_10742 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_10742_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_10742_index

Properties

Name: pg_toast_10742_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_10747

Properties

Name: pg_toast_10747 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_10747_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_10747_index

Properties

Name: pg_toast_10747_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_10752

Properties

Name: pg_toast_10752 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_10752_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_10752_index

Properties

Name: pg_toast_10752_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_10757

Properties

Name: pg_toast_10757 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_10757_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_10757_index

Properties

Name: pg_toast_10757_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_10762

Properties

Name: pg_toast_10762 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_10762_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_10762_index

Properties

Name: pg_toast_10762_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_10767

Properties

Name: pg_toast_10767 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_10767_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_10767_index

Properties

Name: pg_toast_10767_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_1255

Properties

Name: pg_toast_1255 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_1255_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_1255_index

Properties

Name: pg_toast_1255_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_1260

Properties

Name: pg_toast_1260 
Owner: postgres 
Tablespace: pg_global 
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_1260_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_1260_index

Properties

Name: pg_toast_1260_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_1262

Properties

Name: pg_toast_1262 
Owner: postgres 
Tablespace: pg_global 
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_1262_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_1262_index

Properties

Name: pg_toast_1262_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_2396

Properties

Name: pg_toast_2396 
Owner: postgres 
Tablespace: pg_global 
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_2396_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_2396_index

Properties

Name: pg_toast_2396_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_2604

Properties

Name: pg_toast_2604 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_2604_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_2604_index

Properties

Name: pg_toast_2604_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_2606

Properties

Name: pg_toast_2606 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_2606_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_2606_index

Properties

Name: pg_toast_2606_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_2609

Properties

Name: pg_toast_2609 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_2609_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_2609_index

Properties

Name: pg_toast_2609_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_2618

Properties

Name: pg_toast_2618 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_2618_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_2618_index

Properties

Name: pg_toast_2618_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_toast_2619

Properties

Name: pg_toast_2619 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 chunk_id oid -1   
 chunk_seq int4 -1   
 chunk_data bytea -1   
Total: 9 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_toast_2619_index    
Total: 1 index(es)

SQL

See Also

List of tables

Indexes


Index: pg_toast_2619_index

Properties

Name: pg_toast_2619_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 chunk_id 
 chunk_seq 
Total: 2 index column(s)

SQL

See Also

List of indexes



Types


Type: pg_toast_10737

Properties

Name: pg_toast_10737 
OID: 10740 
Owner: postgres 
Alias: pg_toast.pg_toast_10737 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_10742

Properties

Name: pg_toast_10742 
OID: 10745 
Owner: postgres 
Alias: pg_toast.pg_toast_10742 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_10747

Properties

Name: pg_toast_10747 
OID: 10750 
Owner: postgres 
Alias: pg_toast.pg_toast_10747 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_10752

Properties

Name: pg_toast_10752 
OID: 10755 
Owner: postgres 
Alias: pg_toast.pg_toast_10752 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_10757

Properties

Name: pg_toast_10757 
OID: 10760 
Owner: postgres 
Alias: pg_toast.pg_toast_10757 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_10762

Properties

Name: pg_toast_10762 
OID: 10765 
Owner: postgres 
Alias: pg_toast.pg_toast_10762 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_10767

Properties

Name: pg_toast_10767 
OID: 10770 
Owner: postgres 
Alias: pg_toast.pg_toast_10767 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_1255

Properties

Name: pg_toast_1255 
OID: 10288 
Owner: postgres 
Alias: pg_toast.pg_toast_1255 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_1260

Properties

Name: pg_toast_1260 
OID: 10291 
Owner: postgres 
Alias: pg_toast.pg_toast_1260 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_1262

Properties

Name: pg_toast_1262 
OID: 10292 
Owner: postgres 
Alias: pg_toast.pg_toast_1262 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_2396

Properties

Name: pg_toast_2396 
OID: 10293 
Owner: postgres 
Alias: pg_toast.pg_toast_2396 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_2604

Properties

Name: pg_toast_2604 
OID: 10285 
Owner: postgres 
Alias: pg_toast.pg_toast_2604 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_2606

Properties

Name: pg_toast_2606 
OID: 10286 
Owner: postgres 
Alias: pg_toast.pg_toast_2606 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_2609

Properties

Name: pg_toast_2609 
OID: 10287 
Owner: postgres 
Alias: pg_toast.pg_toast_2609 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_2618

Properties

Name: pg_toast_2618 
OID: 10289 
Owner: postgres 
Alias: pg_toast.pg_toast_2618 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_toast_2619

Properties

Name: pg_toast_2619 
OID: 10290 
Owner: postgres 
Alias: pg_toast.pg_toast_2619 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types



Schema: public

Properties

Name: public 
Owner: postgres 
System:  
Comment: Standard public schema 

Aggregates

NameOwnerComment
 avg1(interval) postgres  
Total: 1 aggregate(s)

Conversions

NameOwnerComment
 ascii_to_mic postgres  
Total: 1 conversion(s)

Domains

NameComment
 domain1 test domain 
 rrr  
Total: 2 domain(s)

Functions

NameOwnerComment
 abbrev(inet) postgres  
Total: 1 function(s)

Trigger functions

NameOwnerComment
 RI_FKey_cascade_del postgres  
Total: 1 trigger function(s)

Procedures

NameOwnerComment
 pg_stat_file(IN filename text, OUT size bigint, OUT access timestamp with time zone, OUT modification timestamp with time zone, OUT change timestamp with time zone, OUT creation timestamp with time zone, OUT isdir boolean) postgres  
 pg_timezone_abbrevs(OUT abbrev text, OUT utc_offset interval, OUT is_dst boolean) postgres  
Total: 2 procedure(s)

Operators

NameOwnerComment
 ! (int8) postgres  
Total: 1 operator(s)

Operator classses

NameOwnerComment
 _char_ops1 postgres  
Total: 1 opclass(s)

Sequences

NameOwnerComment
 sq_1 postgres  
 sq_example postgres example sequence 
 ww postgres ddssdss 
Total: 3 sequence(s)

Tables

NameOwnerTablespaceComment
 pg_amop postgres   
 pg_amop1 postgres   
Total: 2 table(s)

Types

NameOwnerComment
 PIPPO postgres  
 pg_amop postgres  
 pg_amop1 postgres  
 sq_1 postgres  
 sq_example postgres  
 view1 postgres  
 ww postgres  
Total: 7 type(s)

Views

NameOwnerComment
 view1 postgres example view 
Total: 1 view(s)

See Also

List of schemas

Aggregates


Aggregate: avg1(interval)

Properties

Name: avg1(interval) 
Input type: interval 
Owner: postgres 
State type: interval[] 
State function: interval_avg 
Final type: interval 
Final function: interval_avg 
Sort Operator:  
Initial condition: {0 second,0 second} 
System aggregate?:  
Comment:  

SQL


CREATE AGGREGATE avg1 (
    BASETYPE = interval,
    SFUNC = interval_accum,
    STYPE = interval[],
    INITCOND = '{0 second,0 second}',
    FINALFUNC = interval_avg
);


ALTER AGGREGATE public.avg1(interval) OWNER TO postgres;

See Also

List of aggregates


Conversions


Conversion: ascii_to_mic

Properties

Name: ascii_to_mic 
Owner: postgres 
Schema: public 
From: SQL_ASCII 
To: MULE_INTERNAL 
Function: ascii_to_mic 
Default:  
System:  
Comment:  

SQL


CREATE DEFAULT CONVERSION ascii_to_mic FOR 'SQL_ASCII' TO 'MULE_INTERNAL' FROM ascii_to_mic;


ALTER CONVERSION public.ascii_to_mic OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

See Also

List of conversions


Domains


Domain: domain1

Properties

Name: domain1 
OID: 16449 
Owner: postgres 
Base type: bigint 
Default:
Check:  
Not Null:  
Comment: test domain 

SQL


CREATE DOMAIN domain1 AS bigint NOT NULL DEFAULT 1;


ALTER DOMAIN public.domain1 OWNER TO postgres;

See Also

List of domains


Domain: rrr

Properties

Name: rrr 
OID: 16450 
Owner: postgres 
Base type: integer 
Default: 34 
Check: CHECK ((VALUE > 33)) 
Not Null:  
Comment:  

SQL


CREATE DOMAIN rrr AS integer NOT NULL DEFAULT 34
    CONSTRAINT rrr_check CHECK ((VALUE > 33));


ALTER DOMAIN public.rrr OWNER TO postgres;

See Also

List of domains


Functions


Function: abbrev(inet)

Properties

Name: abbrev 
Specific name: abbrev(inet) 
Owner: postgres 
Argument count:
Return type: text 
Language: internal 
Return a set:  
Source: inet_abbrev 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION abbrev(inet) RETURNS text
    AS $$inet_abbrev$$
    LANGUAGE internal IMMUTABLE STRICT;


ALTER FUNCTION public.abbrev(inet) OWNER TO postgres;

See Also

List of functions


Trigger Functions


Trigger function: RI_FKey_cascade_del

Properties

Name: RI_FKey_cascade_del 
Owner: postgres 
Argument count:
Return type: trigger 
Language: internal 
Return a set:  
Source: RI_FKey_cascade_del 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION "RI_FKey_cascade_del"() RETURNS "trigger"
    AS $$RI_FKey_cascade_del$$
    LANGUAGE internal STRICT;


ALTER FUNCTION public."RI_FKey_cascade_del"() OWNER TO postgres;

See Also

List of trigger functions


Procedures


Procedure: pg_stat_file(IN filename text, OUT size bigint, OUT access timestamp with time zone, OUT modification timestamp with time zone, OUT change timestamp with time zone, OUT creation timestamp with time zone, OUT isdir boolean)

Properties

Name: pg_stat_file 
Specific name: pg_stat_file(IN filename text, OUT size bigint, OUT access timestamp with time zone, OUT modification timestamp with time zone, OUT change timestamp with time zone, OUT creation timestamp with time zone, OUT isdir boolean) 
Owner: postgres 
Argument count:
Return type: record 
Language: internal 
Return a set:  
Source: pg_stat_file 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION pg_stat_file(filename text, OUT size bigint, OUT "access" timestamp with time zone, OUT modification timestamp with time zone, OUT change timestamp with time zone, OUT creation timestamp with time zone, OUT isdir boolean) RETURNS record
    AS $$pg_stat_file$$
    LANGUAGE internal STRICT;


ALTER FUNCTION public.pg_stat_file(filename text, OUT size bigint, OUT "access" timestamp with time zone, OUT modification timestamp with time zone, OUT change timestamp with time zone, OUT creation timestamp with time zone, OUT isdir boolean) OWNER TO postgres;

See Also

List of procedures


Procedure: pg_timezone_abbrevs(OUT abbrev text, OUT utc_offset interval, OUT is_dst boolean)

Properties

Name: pg_timezone_abbrevs 
Specific name: pg_timezone_abbrevs(OUT abbrev text, OUT utc_offset interval, OUT is_dst boolean) 
Owner: postgres 
Argument count:
Return type: record 
Language: internal 
Return a set:  
Source: pg_timezone_abbrevs 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION pg_timezone_abbrevs(OUT abbrev text, OUT utc_offset interval, OUT is_dst boolean) RETURNS SETOF record
    AS $$pg_timezone_abbrevs$$
    LANGUAGE internal STABLE STRICT;


ALTER FUNCTION public.pg_timezone_abbrevs(OUT abbrev text, OUT utc_offset interval, OUT is_dst boolean) OWNER TO postgres;

See Also

List of procedures


Operators


Operator: ! (int8)

Properties

Name:
OID: 16480 
Owner: postgres 
Kind: POSTFIX 
Left type: int8 
Right type:  
Result type: numeric 
Commutator:  
Negator:  
Join function:  
Restrict function:  
Left Sort operator:  
Right Sort operator:  
Less Than operator:  
Greater Than Operator:  
Supports hash:  
Comment:  

SQL


CREATE OPERATOR ! (
    PROCEDURE = numeric_fac,
    LEFTARG = bigint
);


ALTER OPERATOR public.! (bigint, NONE) OWNER TO postgres;

See Also

List of operators


Operator Classes


Operator class: _char_ops1

Properties

Name: _char_ops1 
OID: 16476 
Owner: postgres 
Default:  
For type: _char 
Access method: gin 
Storage:  
Comment:  
Operator: 1 &&(anyarray,anyarray) 
Operator: 2 @>(anyarray,anyarray) 
Operator: 3 <@(anyarray,anyarray) 
Operator: 4 =(anyarray,anyarray) 
Function: btcharcmp("char", "char") 
Function: ginarrayextract(anyarray, internal) 
Function: ginarrayextract(anyarray, internal) 
Function: ginarrayconsistent(internal, smallint, internal) 

SQL


CREATE OPERATOR CLASS _char_ops1
    FOR TYPE "char"[] USING gin AS
    OPERATOR 1 &&(anyarray,anyarray) ,
    OPERATOR 2 @>(anyarray,anyarray) ,
    OPERATOR 3 <@(anyarray,anyarray) RECHECK ,
    OPERATOR 4 =(anyarray,anyarray) RECHECK ,
    FUNCTION 1 btcharcmp("char","char") ,
    FUNCTION 2 ginarrayextract(anyarray,internal) ,
    FUNCTION 3 ginarrayextract(anyarray,internal) ,
    FUNCTION 4 ginarrayconsistent(internal,smallint,internal);


ALTER OPERATOR CLASS public._char_ops1 USING gin OWNER TO postgres;

See Also

List of operator classes


Sequences


Sequence: sq_1

Properties

Name: sq_1 
OID: 16445 
Owner: postgres 
Current value:
Minimum:
Maximum: 9223372036854775807 
Increment:
Cache:
Cycled:  
Comment:  

SQL


CREATE SEQUENCE sq_1
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.sq_1 OWNER TO postgres;

See Also

List of sequences


Sequence: sq_example

Properties

Name: sq_example 
OID: 16443 
Owner: postgres 
Current value:
Minimum:
Maximum: 9223372036854775807 
Increment:
Cache:
Cycled:  
Comment: example sequence 

SQL


CREATE SEQUENCE sq_example
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1
    CYCLE;


ALTER TABLE public.sq_example OWNER TO postgres;

See Also

List of sequences


Sequence: ww

Properties

Name: ww 
OID: 16447 
Owner: postgres 
Current value:
Minimum:
Maximum: 12 
Increment:
Cache:
Cycled:  
Comment: ddssdss 

SQL


CREATE SEQUENCE ww
    START WITH 1
    INCREMENT BY 1
    MAXVALUE 12
    NO MINVALUE
    CACHE 1
    CYCLE;


ALTER TABLE public.ww OWNER TO postgres;

See Also

List of sequences


Tables


Table: pg_amop

Properties

Name: pg_amop 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 amopclaid oid -1   
 amopsubtype oid -1   
 amopstrategy int2 -1   
 amopreqcheck bool -1   
 amopopr oid -1   
Total: 11 column(s)

Indexes

NameUniquePrimary keyClustered
 pg_amop_opc_strat_index    
 pg_amop_opr_opc_index    
Total: 2 index(es)

SQL


CREATE TABLE pg_amop (
    amopclaid oid NOT NULL,
    amopsubtype oid NOT NULL,
    amopstrategy smallint NOT NULL,
    amopreqcheck boolean NOT NULL,
    amopopr oid NOT NULL
);


ALTER TABLE public.pg_amop OWNER TO postgres;

See Also

List of tables

Indexes


Index: pg_amop_opc_strat_index

Properties

Name: pg_amop_opc_strat_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 amopclaid 
 amopsubtype 
 amopstrategy 
Total: 3 index column(s)

SQL

See Also

List of indexes


Index: pg_amop_opr_opc_index

Properties

Name: pg_amop_opr_opc_index 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 amopclaid 
 amopopr 
Total: 2 index column(s)

SQL

See Also

List of indexes



Table: pg_amop1

Properties

Name: pg_amop1 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 amopclaid oid -1   
 amopsubtype oid -1   
 amopstrategy int2 -1   
 amopreqcheck bool -1   
 amopopr oid -1   
Total: 11 column(s)

Constraints

NameTypeDeffered
 ddd unique  
Total: 1 constraint(s)

Indexes

NameUniquePrimary keyClustered
 index1    
Total: 1 index(es)

Rules

NameTypeInstead
 ddd DELETE  
Total: 1 rule(s)

Triggers

NameTrigger functionEnabledDeferrableInitially deferred
 tr_amo1 flatfile_update_trigger    
Total: 1 trigger(s)

SQL


CREATE TABLE pg_amop1 (
    amopclaid oid NOT NULL,
    amopsubtype oid NOT NULL,
    amopstrategy smallint NOT NULL,
    amopreqcheck boolean NOT NULL,
    amopopr oid NOT NULL
);


ALTER TABLE public.pg_amop1 OWNER TO postgres;

See Also

List of tables

Indexes


Index: index1

Properties

Name: index1 
Unique:  
Primary key:  
Clustered:  
Internar expression tree:  
Internar predicate tree:  

Columns

Name
 amopclaid 
Total: 1 index column(s)

SQL


CREATE UNIQUE INDEX index1 ON pg_amop1 USING btree (amopclaid);

ALTER TABLE pg_amop1 CLUSTER ON index1;


See Also

List of indexes


Rules


Rule: ddd

Properties

Name: ddd 
Table: pg_amop1 
Type: DELETE 
Is instead:  

SQL


CREATE RULE ddd AS ON DELETE TO pg_amop1 WHERE (old.amopclaid > (1)::oid) DO NOTHING;


See Also

Table overview


Triggers


Trigger: tr_amo1

Properties

Name: tr_amo1 
Fires: ROW 
Timing: BEFORE 
Insert:  
Delete:  
Update:  
Trigger function: flatfile_update_trigger 
Enabled:  
Deferrable:  
Initially deferred:  
Comment: trigger 

SQL


CREATE TRIGGER tr_amo1
    BEFORE UPDATE ON pg_amop1
    FOR EACH ROW
    EXECUTE PROCEDURE flatfile_update_trigger();


See Also

List of triggers


Constraints


Constraint: ddd

Properties

Name: ddd 
Type: unique 
Deffered:  
Deffered by default:  
Reference table:  
FK update action code:  
FK deletion action code:  
FK match typa:  
CHECK expression:  
Comment: dddd 

SQL


ALTER TABLE ONLY pg_amop1
    ADD CONSTRAINT ddd UNIQUE (amopclaid);


See Also

List of constraints



Types


Type: PIPPO

Properties

Name: PIPPO 
OID: 16469 
Owner: postgres 
Alias: "PIPPO" 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL


CREATE TYPE "PIPPO" AS (
    one money,
    two numeric(10,10)
);


ALTER TYPE public."PIPPO" OWNER TO postgres;

See Also

List of types


Type: pg_amop

Properties

Name: pg_amop 
OID: 16453 
Owner: postgres 
Alias: public.pg_amop 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: pg_amop1

Properties

Name: pg_amop1 
OID: 16455 
Owner: postgres 
Alias: pg_amop1 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: sq_1

Properties

Name: sq_1 
OID: 16446 
Owner: postgres 
Alias: sq_1 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: sq_example

Properties

Name: sq_example 
OID: 16444 
Owner: postgres 
Alias: sq_example 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: view1

Properties

Name: view1 
OID: 16472 
Owner: postgres 
Alias: view1 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: ww

Properties

Name: ww 
OID: 16448 
Owner: postgres 
Alias: ww 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Views


View: view1

Properties

Name: view1 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment: example view 

Columns

NameTypeLength
 ?column? int4 -1 
Total: 1 column(s)

Rules

NameTypeInstead
 view1_ondelete DELETE  
Total: 1 rule(s)

SQL


CREATE VIEW view1 AS
    SELECT 1 FROM pg_index;


ALTER TABLE public.view1 OWNER TO postgres;

See Also

List of views

Rules


Rule: view1_ondelete

Properties

Name: view1_ondelete 
View: view1 
Type: DELETE 
Instead:  
Comment:  

SQL


CREATE RULE view1_ondelete AS ON DELETE TO view1 WHERE (1 > 1) DO NOTHING;


See Also

View overview




Schema: information_schema

Properties

Name: information_schema 
Owner: postgres 
System:  
Comment:  

Domains

NameComment
 domain1 test domain 
 rrr  
Total: 2 domain(s)

Functions

NameOwnerComment
 _pg_char_max_length(oid, integer) postgres  
 _pg_char_octet_length(oid, integer) postgres  
 _pg_datetime_precision(oid, integer) postgres  
 _pg_index_position(oid, smallint) postgres  
 _pg_keyissubset() postgres  
 _pg_keysequal() postgres  
 _pg_numeric_precision(oid, integer) postgres  
 _pg_numeric_precision_radix(oid, integer) postgres  
 _pg_numeric_scale(oid, integer) postgres  
 _pg_truetypid(pg_attribute, pg_type) postgres  
 _pg_truetypmod(pg_attribute, pg_type) postgres  
 _pg_underlying_index(oid) postgres  
Total: 12 function(s)

Procedures

NameOwnerComment
 _pg_expandarray(IN anyarray, OUT x anyelement, OUT n integer) postgres  
Total: 1 procedure(s)

Tables

NameOwnerTablespaceComment
 sql_features postgres   
 sql_implementation_info postgres   
 sql_languages postgres   
 sql_packages postgres   
 sql_parts postgres   
 sql_sizing postgres   
 sql_sizing_profiles postgres   
Total: 7 table(s)

Types

NameOwnerComment
 administrable_role_authorizations postgres  
 applicable_roles postgres  
 attributes postgres  
 check_constraint_routine_usage postgres  
 check_constraints postgres  
 column_domain_usage postgres  
 column_privileges postgres  
 column_udt_usage postgres  
 columns postgres  
 constraint_column_usage postgres  
 constraint_table_usage postgres  
 data_type_privileges postgres  
 domain_constraints postgres  
 domain_udt_usage postgres  
 domains postgres  
 element_types postgres  
 enabled_roles postgres  
 information_schema_catalog_name postgres  
 key_column_usage postgres  
 parameters postgres  
 referential_constraints postgres  
 role_column_grants postgres  
 role_routine_grants postgres  
 role_table_grants postgres  
 role_usage_grants postgres  
 routine_privileges postgres  
 routines postgres  
 schemata postgres  
 sequences postgres  
 sql_features postgres  
 sql_implementation_info postgres  
 sql_languages postgres  
 sql_packages postgres  
 sql_parts postgres  
 sql_sizing postgres  
 sql_sizing_profiles postgres  
 table_constraints postgres  
 table_privileges postgres  
 tables postgres  
 triggered_update_columns postgres  
 triggers postgres  
 usage_privileges postgres  
 view_column_usage postgres  
 view_routine_usage postgres  
 view_table_usage postgres  
 views postgres  
Total: 46 type(s)

Views

NameOwnerComment
 administrable_role_authorizations postgres  
 applicable_roles postgres  
 attributes postgres  
 check_constraint_routine_usage postgres  
 check_constraints postgres  
 column_domain_usage postgres  
 column_privileges postgres  
 column_udt_usage postgres  
 columns postgres  
 constraint_column_usage postgres  
 constraint_table_usage postgres  
 data_type_privileges postgres  
 domain_constraints postgres  
 domain_udt_usage postgres  
 domains postgres  
 element_types postgres  
 enabled_roles postgres  
 information_schema_catalog_name postgres  
 key_column_usage postgres  
 parameters postgres  
 referential_constraints postgres  
 role_column_grants postgres  
 role_routine_grants postgres  
 role_table_grants postgres  
 role_usage_grants postgres  
 routine_privileges postgres  
 routines postgres  
 schemata postgres  
 sequences postgres  
 table_constraints postgres  
 table_privileges postgres  
 tables postgres  
 triggered_update_columns postgres  
 triggers postgres  
 usage_privileges postgres  
 view_column_usage postgres  
 view_routine_usage postgres  
 view_table_usage postgres  
 views postgres  
Total: 39 view(s)

See Also

List of schemas

Domains


Domain: domain1

Properties

Name: domain1 
OID: 16449 
Owner: postgres 
Base type: bigint 
Default:
Check:  
Not Null:  
Comment: test domain 

SQL

See Also

List of domains


Domain: rrr

Properties

Name: rrr 
OID: 16450 
Owner: postgres 
Base type: integer 
Default: 34 
Check: CHECK ((VALUE > 33)) 
Not Null:  
Comment:  

SQL

See Also

List of domains


Functions


Function: _pg_char_max_length(oid, integer)

Properties

Name: _pg_char_max_length 
Specific name: _pg_char_max_length(oid, integer) 
Owner: postgres 
Argument count:
Return type: int4 
Language: sql 
Return a set:  
Source: SELECT CASE WHEN $2 = -1 /* default typmod */ THEN null WHEN $1 IN (1042, 1043) /* char, varchar */ THEN $2 - 4 WHEN $1 IN (1560, 1562) /* bit, varbit */ THEN $2 ELSE null END 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_char_max_length(typid oid, typmod integer) RETURNS integer
    AS $_$SELECT
  CASE WHEN $2 = -1 /* default typmod */
       THEN null
       WHEN $1 IN (1042, 1043) /* char, varchar */
       THEN $2 - 4
       WHEN $1 IN (1560, 1562) /* bit, varbit */
       THEN $2
       ELSE null
  END$_$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION information_schema._pg_char_max_length(typid oid, typmod integer) OWNER TO postgres;

See Also

List of functions


Function: _pg_char_octet_length(oid, integer)

Properties

Name: _pg_char_octet_length 
Specific name: _pg_char_octet_length(oid, integer) 
Owner: postgres 
Argument count:
Return type: int4 
Language: sql 
Return a set:  
Source: SELECT CASE WHEN $1 IN (25, 1042, 1043) /* text, char, varchar */ THEN CAST(2^30 AS integer) ELSE null END 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_char_octet_length(typid oid, typmod integer) RETURNS integer
    AS $_$SELECT
  CASE WHEN $1 IN (25, 1042, 1043) /* text, char, varchar */
       THEN CAST(2^30 AS integer)
       ELSE null
  END$_$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION information_schema._pg_char_octet_length(typid oid, typmod integer) OWNER TO postgres;

See Also

List of functions


Function: _pg_datetime_precision(oid, integer)

Properties

Name: _pg_datetime_precision 
Specific name: _pg_datetime_precision(oid, integer) 
Owner: postgres 
Argument count:
Return type: int4 
Language: sql 
Return a set:  
Source: SELECT CASE WHEN $2 = -1 /* default typmod */ THEN null WHEN $1 IN (1083, 1114, 1184, 1266) /* time, timestamp, same + tz */ THEN $2 WHEN $1 IN (1186) /* interval */ THEN $2 & 65535 ELSE null END 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_datetime_precision(typid oid, typmod integer) RETURNS integer
    AS $_$SELECT
  CASE WHEN $2 = -1 /* default typmod */
       THEN null
       WHEN $1 IN (1083, 1114, 1184, 1266) /* time, timestamp, same + tz */
       THEN $2
       WHEN $1 IN (1186) /* interval */
       THEN $2 & 65535
       ELSE null
  END$_$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION information_schema._pg_datetime_precision(typid oid, typmod integer) OWNER TO postgres;

See Also

List of functions


Function: _pg_index_position(oid, smallint)

Properties

Name: _pg_index_position 
Specific name: _pg_index_position(oid, smallint) 
Owner: postgres 
Argument count:
Return type: int4 
Language: sql 
Return a set:  
Source: SELECT (ss.a).n FROM (SELECT information_schema._pg_expandarray(indkey) AS a FROM pg_catalog.pg_index WHERE indexrelid = $1) ss WHERE (ss.a).x = $2; 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_index_position(oid, smallint) RETURNS integer
    AS $_$
SELECT (ss.a).n FROM
  (SELECT information_schema._pg_expandarray(indkey) AS a
   FROM pg_catalog.pg_index WHERE indexrelid = $1) ss
  WHERE (ss.a).x = $2;
$_$
    LANGUAGE sql STABLE STRICT;


ALTER FUNCTION information_schema._pg_index_position(oid, smallint) OWNER TO postgres;

See Also

List of functions


Function: _pg_keyissubset()

Properties

Name: _pg_keyissubset 
Specific name: _pg_keyissubset() 
Owner: postgres 
Argument count:
Return type: bool 
Language: sql 
Return a set:  
Source: select $1[1] is null or ($1[1] = any ($2) and coalesce(information_schema._pg_keyissubset($1[2:pg_catalog.array_upper($1,1)], $2), true)) 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL

See Also

List of functions


Function: _pg_keysequal()

Properties

Name: _pg_keysequal 
Specific name: _pg_keysequal() 
Owner: postgres 
Argument count:
Return type: bool 
Language: sql 
Return a set:  
Source: select information_schema._pg_keyissubset($1, $2) and information_schema._pg_keyissubset($2, $1) 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL

See Also

List of functions


Function: _pg_numeric_precision(oid, integer)

Properties

Name: _pg_numeric_precision 
Specific name: _pg_numeric_precision(oid, integer) 
Owner: postgres 
Argument count:
Return type: int4 
Language: sql 
Return a set:  
Source: SELECT CASE $1 WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN $2 = -1 THEN null ELSE (($2 - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_numeric_precision(typid oid, typmod integer) RETURNS integer
    AS $_$SELECT
  CASE $1
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN $2 = -1
                   THEN null
                   ELSE (($2 - 4) >> 16) & 65535
                   END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
  END$_$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION information_schema._pg_numeric_precision(typid oid, typmod integer) OWNER TO postgres;

See Also

List of functions


Function: _pg_numeric_precision_radix(oid, integer)

Properties

Name: _pg_numeric_precision_radix 
Specific name: _pg_numeric_precision_radix(oid, integer) 
Owner: postgres 
Argument count:
Return type: int4 
Language: sql 
Return a set:  
Source: SELECT CASE WHEN $1 IN (21, 23, 20, 700, 701) THEN 2 WHEN $1 IN (1700) THEN 10 ELSE null END 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_numeric_precision_radix(typid oid, typmod integer) RETURNS integer
    AS $_$SELECT
  CASE WHEN $1 IN (21, 23, 20, 700, 701) THEN 2
       WHEN $1 IN (1700) THEN 10
       ELSE null
  END$_$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION information_schema._pg_numeric_precision_radix(typid oid, typmod integer) OWNER TO postgres;

See Also

List of functions


Function: _pg_numeric_scale(oid, integer)

Properties

Name: _pg_numeric_scale 
Specific name: _pg_numeric_scale(oid, integer) 
Owner: postgres 
Argument count:
Return type: int4 
Language: sql 
Return a set:  
Source: SELECT CASE WHEN $1 IN (21, 23, 20) THEN 0 WHEN $1 IN (1700) THEN CASE WHEN $2 = -1 THEN null ELSE ($2 - 4) & 65535 END ELSE null END 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_numeric_scale(typid oid, typmod integer) RETURNS integer
    AS $_$SELECT
  CASE WHEN $1 IN (21, 23, 20) THEN 0
       WHEN $1 IN (1700) THEN
            CASE WHEN $2 = -1
                 THEN null
                 ELSE ($2 - 4) & 65535
                 END
       ELSE null
  END$_$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION information_schema._pg_numeric_scale(typid oid, typmod integer) OWNER TO postgres;

See Also

List of functions


Function: _pg_truetypid(pg_attribute, pg_type)

Properties

Name: _pg_truetypid 
Specific name: _pg_truetypid(pg_attribute, pg_type) 
Owner: postgres 
Argument count:
Return type: oid 
Language: sql 
Return a set:  
Source: SELECT CASE WHEN $2.typtype = 'd' THEN $2.typbasetype ELSE $1.atttypid END 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_truetypid(pg_attribute, pg_type) RETURNS oid
    AS $_$SELECT CASE WHEN $2.typtype = 'd' THEN $2.typbasetype ELSE $1.atttypid END$_$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION information_schema._pg_truetypid(pg_attribute, pg_type) OWNER TO postgres;

See Also

List of functions


Function: _pg_truetypmod(pg_attribute, pg_type)

Properties

Name: _pg_truetypmod 
Specific name: _pg_truetypmod(pg_attribute, pg_type) 
Owner: postgres 
Argument count:
Return type: int4 
Language: sql 
Return a set:  
Source: SELECT CASE WHEN $2.typtype = 'd' THEN $2.typtypmod ELSE $1.atttypmod END 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_truetypmod(pg_attribute, pg_type) RETURNS integer
    AS $_$SELECT CASE WHEN $2.typtype = 'd' THEN $2.typtypmod ELSE $1.atttypmod END$_$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION information_schema._pg_truetypmod(pg_attribute, pg_type) OWNER TO postgres;

See Also

List of functions


Function: _pg_underlying_index(oid)

Properties

Name: _pg_underlying_index 
Specific name: _pg_underlying_index(oid) 
Owner: postgres 
Argument count:
Return type: oid 
Language: sql 
Return a set:  
Source: SELECT refobjid FROM pg_catalog.pg_depend WHERE classid = 'pg_catalog.pg_constraint'::pg_catalog.regclass AND objid = $1 AND refclassid = 'pg_catalog.pg_class'::pg_catalog.regclass AND refobjsubid = 0 AND deptype = 'n' 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_underlying_index(oid) RETURNS oid
    AS $_$
SELECT refobjid FROM pg_catalog.pg_depend
  WHERE classid = 'pg_catalog.pg_constraint'::pg_catalog.regclass AND
        objid = $1 AND
        refclassid = 'pg_catalog.pg_class'::pg_catalog.regclass AND
        refobjsubid = 0 AND deptype = 'n'
$_$
    LANGUAGE sql STABLE STRICT;


ALTER FUNCTION information_schema._pg_underlying_index(oid) OWNER TO postgres;

See Also

List of functions


Procedures


Procedure: _pg_expandarray(IN anyarray, OUT x anyelement, OUT n integer)

Properties

Name: _pg_expandarray 
Specific name: _pg_expandarray(IN anyarray, OUT x anyelement, OUT n integer) 
Owner: postgres 
Argument count:
Return type: record 
Language: sql 
Return a set:  
Source: select $1[s], s - pg_catalog.array_lower($1,1) + 1 from pg_catalog.generate_series(pg_catalog.array_lower($1,1), pg_catalog.array_upper($1,1), 1) as g(s) 
Volatility:  
Security of definer:  
Strict:  
Comment:  

SQL


CREATE FUNCTION _pg_expandarray(anyarray, OUT x anyelement, OUT n integer) RETURNS SETOF record
    AS $_$select $1[s], s - pg_catalog.array_lower($1,1) + 1
        from pg_catalog.generate_series(pg_catalog.array_lower($1,1),
                                        pg_catalog.array_upper($1,1),
                                        1) as g(s)$_$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION information_schema._pg_expandarray(anyarray, OUT x anyelement, OUT n integer) OWNER TO postgres;

See Also

List of procedures


Tables


Table: sql_features

Properties

Name: sql_features 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 feature_id character_data -1   
 feature_name character_data -1   
 sub_feature_id character_data -1   
 sub_feature_name character_data -1   
 is_supported character_data -1   
 is_verified_by character_data -1   
 comments character_data -1   
Total: 13 column(s)

SQL


CREATE TABLE sql_features (
    feature_id character_data,
    feature_name character_data,
    sub_feature_id character_data,
    sub_feature_name character_data,
    is_supported character_data,
    is_verified_by character_data,
    comments character_data
);


ALTER TABLE information_schema.sql_features OWNER TO postgres;

See Also

List of tables


Table: sql_implementation_info

Properties

Name: sql_implementation_info 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 implementation_info_id character_data -1   
 implementation_info_name character_data -1   
 integer_value cardinal_number -1   
 character_value character_data -1   
 comments character_data -1   
Total: 11 column(s)

SQL


CREATE TABLE sql_implementation_info (
    implementation_info_id character_data,
    implementation_info_name character_data,
    integer_value cardinal_number,
    character_value character_data,
    comments character_data
);


ALTER TABLE information_schema.sql_implementation_info OWNER TO postgres;

See Also

List of tables


Table: sql_languages

Properties

Name: sql_languages 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 sql_language_source character_data -1   
 sql_language_year character_data -1   
 sql_language_conformance character_data -1   
 sql_language_integrity character_data -1   
 sql_language_implementation character_data -1   
 sql_language_binding_style character_data -1   
 sql_language_programming_language character_data -1   
Total: 13 column(s)

SQL


CREATE TABLE sql_languages (
    sql_language_source character_data,
    sql_language_year character_data,
    sql_language_conformance character_data,
    sql_language_integrity character_data,
    sql_language_implementation character_data,
    sql_language_binding_style character_data,
    sql_language_programming_language character_data
);


ALTER TABLE information_schema.sql_languages OWNER TO postgres;

See Also

List of tables


Table: sql_packages

Properties

Name: sql_packages 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 feature_id character_data -1   
 feature_name character_data -1   
 is_supported character_data -1   
 is_verified_by character_data -1   
 comments character_data -1   
Total: 11 column(s)

SQL


CREATE TABLE sql_packages (
    feature_id character_data,
    feature_name character_data,
    is_supported character_data,
    is_verified_by character_data,
    comments character_data
);


ALTER TABLE information_schema.sql_packages OWNER TO postgres;

See Also

List of tables


Table: sql_parts

Properties

Name: sql_parts 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 feature_id character_data -1   
 feature_name character_data -1   
 is_supported character_data -1   
 is_verified_by character_data -1   
 comments character_data -1   
Total: 11 column(s)

SQL


CREATE TABLE sql_parts (
    feature_id character_data,
    feature_name character_data,
    is_supported character_data,
    is_verified_by character_data,
    comments character_data
);


ALTER TABLE information_schema.sql_parts OWNER TO postgres;

See Also

List of tables


Table: sql_sizing

Properties

Name: sql_sizing 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 sizing_id cardinal_number -1   
 sizing_name character_data -1   
 supported_value cardinal_number -1   
 comments character_data -1   
Total: 10 column(s)

SQL


CREATE TABLE sql_sizing (
    sizing_id cardinal_number,
    sizing_name character_data,
    supported_value cardinal_number,
    comments character_data
);


ALTER TABLE information_schema.sql_sizing OWNER TO postgres;

See Also

List of tables


Table: sql_sizing_profiles

Properties

Name: sql_sizing_profiles 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

NameTypeLengthDefault valueComment
 tableoid oid -1   
 cmax cid -1   
 xmax xid -1   
 cmin cid -1   
 xmin xid -1   
 ctid tid -1   
 sizing_id cardinal_number -1   
 sizing_name character_data -1   
 profile_id character_data -1   
 required_value cardinal_number -1   
 comments character_data -1   
Total: 11 column(s)

SQL


CREATE TABLE sql_sizing_profiles (
    sizing_id cardinal_number,
    sizing_name character_data,
    profile_id character_data,
    required_value cardinal_number,
    comments character_data
);


ALTER TABLE information_schema.sql_sizing_profiles OWNER TO postgres;

See Also

List of tables


Types


Type: administrable_role_authorizations

Properties

Name: administrable_role_authorizations 
OID: 10647 
Owner: postgres 
Alias: information_schema.administrable_role_authorizations 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: applicable_roles

Properties

Name: applicable_roles 
OID: 10644 
Owner: postgres 
Alias: information_schema.applicable_roles 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: attributes

Properties

Name: attributes 
OID: 10650 
Owner: postgres 
Alias: information_schema.attributes 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: check_constraint_routine_usage

Properties

Name: check_constraint_routine_usage 
OID: 10654 
Owner: postgres 
Alias: information_schema.check_constraint_routine_usage 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: check_constraints

Properties

Name: check_constraints 
OID: 10657 
Owner: postgres 
Alias: information_schema.check_constraints 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: column_domain_usage

Properties

Name: column_domain_usage 
OID: 10661 
Owner: postgres 
Alias: information_schema.column_domain_usage 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: column_privileges

Properties

Name: column_privileges 
OID: 10665 
Owner: postgres 
Alias: information_schema.column_privileges 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: column_udt_usage

Properties

Name: column_udt_usage 
OID: 10669 
Owner: postgres 
Alias: information_schema.column_udt_usage 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: columns

Properties

Name: columns 
OID: 10673 
Owner: postgres 
Alias: information_schema.columns 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: constraint_column_usage

Properties

Name: constraint_column_usage 
OID: 10677 
Owner: postgres 
Alias: information_schema.constraint_column_usage 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: constraint_table_usage

Properties

Name: constraint_table_usage 
OID: 10681 
Owner: postgres 
Alias: information_schema.constraint_table_usage 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: data_type_privileges

Properties

Name: data_type_privileges 
OID: 10811 
Owner: postgres 
Alias: information_schema.data_type_privileges 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: domain_constraints

Properties

Name: domain_constraints 
OID: 10684 
Owner: postgres 
Alias: information_schema.domain_constraints 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: domain_udt_usage

Properties

Name: domain_udt_usage 
OID: 10687 
Owner: postgres 
Alias: information_schema.domain_udt_usage 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: domains

Properties

Name: domains 
OID: 10690 
Owner: postgres 
Alias: information_schema.domains 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: element_types

Properties

Name: element_types 
OID: 10815 
Owner: postgres 
Alias: information_schema.element_types 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: enabled_roles

Properties

Name: enabled_roles 
OID: 10694 
Owner: postgres 
Alias: information_schema.enabled_roles 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: information_schema_catalog_name

Properties

Name: information_schema_catalog_name 
OID: 10640 
Owner: postgres 
Alias: information_schema.information_schema_catalog_name 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: key_column_usage

Properties

Name: key_column_usage 
OID: 10697 
Owner: postgres 
Alias: information_schema.key_column_usage 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: parameters

Properties

Name: parameters 
OID: 10701 
Owner: postgres 
Alias: information_schema.parameters 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: referential_constraints

Properties

Name: referential_constraints 
OID: 10705 
Owner: postgres 
Alias: information_schema.referential_constraints 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: role_column_grants

Properties

Name: role_column_grants 
OID: 10709 
Owner: postgres 
Alias: information_schema.role_column_grants 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: role_routine_grants

Properties

Name: role_routine_grants 
OID: 10713 
Owner: postgres 
Alias: information_schema.role_routine_grants 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: role_table_grants

Properties

Name: role_table_grants 
OID: 10717 
Owner: postgres 
Alias: information_schema.role_table_grants 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: role_usage_grants

Properties

Name: role_usage_grants 
OID: 10721 
Owner: postgres 
Alias: information_schema.role_usage_grants 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: routine_privileges

Properties

Name: routine_privileges 
OID: 10724 
Owner: postgres 
Alias: information_schema.routine_privileges 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: routines

Properties

Name: routines 
OID: 10728 
Owner: postgres 
Alias: information_schema.routines 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: schemata

Properties

Name: schemata 
OID: 10732 
Owner: postgres 
Alias: information_schema.schemata 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: sequences

Properties

Name: sequences 
OID: 10735 
Owner: postgres 
Alias: information_schema.sequences 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: sql_features

Properties

Name: sql_features 
OID: 10738 
Owner: postgres 
Alias: information_schema.sql_features 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: sql_implementation_info

Properties

Name: sql_implementation_info 
OID: 10743 
Owner: postgres 
Alias: information_schema.sql_implementation_info 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: sql_languages

Properties

Name: sql_languages 
OID: 10748 
Owner: postgres 
Alias: information_schema.sql_languages 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: sql_packages

Properties

Name: sql_packages 
OID: 10753 
Owner: postgres 
Alias: information_schema.sql_packages 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: sql_parts

Properties

Name: sql_parts 
OID: 10758 
Owner: postgres 
Alias: information_schema.sql_parts 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: sql_sizing

Properties

Name: sql_sizing 
OID: 10763 
Owner: postgres 
Alias: information_schema.sql_sizing 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: sql_sizing_profiles

Properties

Name: sql_sizing_profiles 
OID: 10768 
Owner: postgres 
Alias: information_schema.sql_sizing_profiles 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: table_constraints

Properties

Name: table_constraints 
OID: 10773 
Owner: postgres 
Alias: information_schema.table_constraints 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: table_privileges

Properties

Name: table_privileges 
OID: 10777 
Owner: postgres 
Alias: information_schema.table_privileges 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: tables

Properties

Name: tables 
OID: 10781 
Owner: postgres 
Alias: information_schema.tables 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: triggered_update_columns

Properties

Name: triggered_update_columns 
OID: 10785 
Owner: postgres 
Alias: information_schema.triggered_update_columns 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: triggers

Properties

Name: triggers 
OID: 10788 
Owner: postgres 
Alias: information_schema.triggers 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: usage_privileges

Properties

Name: usage_privileges 
OID: 10792 
Owner: postgres 
Alias: information_schema.usage_privileges 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: view_column_usage

Properties

Name: view_column_usage 
OID: 10795 
Owner: postgres 
Alias: information_schema.view_column_usage 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: view_routine_usage

Properties

Name: view_routine_usage 
OID: 10799 
Owner: postgres 
Alias: information_schema.view_routine_usage 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: view_table_usage

Properties

Name: view_table_usage 
OID: 10803 
Owner: postgres 
Alias: information_schema.view_table_usage 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Type: views

Properties

Name: views 
OID: 10807 
Owner: postgres 
Alias: information_schema.views 
Aligment: double 
Internal length: -1 
Default:  
Passed by value:  
Input function: record_in 
Output function: record_out 
Receive function: record_recv 
Send function: record_send 
Storage: EXTENDED 
Comment:  

SQL

See Also

List of types


Views


View: administrable_role_authorizations

Properties

Name: administrable_role_authorizations 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 grantee sql_identifier -1 
 role_name sql_identifier -1 
 is_grantable character_data -1 
Total: 3 column(s)

SQL


CREATE VIEW administrable_role_authorizations AS
    SELECT applicable_roles.grantee, applicable_roles.role_name, applicable_roles.is_grantable FROM applicable_roles WHERE ((applicable_roles.is_grantable)::text = 'YES'::text);


ALTER TABLE information_schema.administrable_role_authorizations OWNER TO postgres;

See Also

List of views


View: applicable_roles

Properties

Name: applicable_roles 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 grantee sql_identifier -1 
 role_name sql_identifier -1 
 is_grantable character_data -1 
Total: 3 column(s)

SQL


CREATE VIEW applicable_roles AS
    SELECT (a.rolname)::sql_identifier AS grantee, (b.rolname)::sql_identifier AS role_name, (CASE WHEN m.admin_option THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_grantable FROM ((pg_auth_members m JOIN pg_authid a ON ((m.member = a.oid))) JOIN pg_authid b ON ((m.roleid = b.oid))) WHERE pg_has_role(a.oid, 'USAGE'::text);


ALTER TABLE information_schema.applicable_roles OWNER TO postgres;

See Also

List of views


View: attributes

Properties

Name: attributes 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 udt_catalog sql_identifier -1 
 udt_schema sql_identifier -1 
 udt_name sql_identifier -1 
 attribute_name sql_identifier -1 
 ordinal_position cardinal_number -1 
 attribute_default character_data -1 
 is_nullable character_data -1 
 data_type character_data -1 
 character_maximum_length cardinal_number -1 
 character_octet_length cardinal_number -1 
 character_set_catalog sql_identifier -1 
 character_set_schema sql_identifier -1 
 character_set_name sql_identifier -1 
 collation_catalog sql_identifier -1 
 collation_schema sql_identifier -1 
 collation_name sql_identifier -1 
 numeric_precision cardinal_number -1 
 numeric_precision_radix cardinal_number -1 
 numeric_scale cardinal_number -1 
 datetime_precision cardinal_number -1 
 interval_type character_data -1 
 interval_precision character_data -1 
 attribute_udt_catalog sql_identifier -1 
 attribute_udt_schema sql_identifier -1 
 attribute_udt_name sql_identifier -1 
 scope_catalog sql_identifier -1 
 scope_schema sql_identifier -1 
 scope_name sql_identifier -1 
 maximum_cardinality cardinal_number -1 
 dtd_identifier sql_identifier -1 
 is_derived_reference_attribute character_data -1 
Total: 31 column(s)

SQL


CREATE VIEW attributes AS
    SELECT (current_database())::sql_identifier AS udt_catalog, (nc.nspname)::sql_identifier AS udt_schema, (c.relname)::sql_identifier AS udt_name, (a.attname)::sql_identifier AS attribute_name, (a.attnum)::cardinal_number AS ordinal_position, (pg_get_expr(ad.adbin, ad.adrelid))::character_data AS attribute_default, (CASE WHEN (a.attnotnull OR ((t.typtype = 'd'::"char") AND t.typnotnull)) THEN 'NO'::text ELSE 'YES'::text END)::character_data AS is_nullable, (CASE WHEN ((t.typelem <> (0)::oid) AND (t.typlen = -1)) THEN 'ARRAY'::text WHEN (nt.nspname = 'pg_catalog'::name) THEN format_type(a.atttypid, NULL::integer) ELSE 'USER-DEFINED'::text END)::character_data AS data_type, (_pg_char_max_length(_pg_truetypid(a.*, t.*), _pg_truetypmod(a.*, t.*)))::cardinal_number AS character_maximum_length, (_pg_char_octet_length(_pg_truetypid(a.*, t.*), _pg_truetypmod(a.*, t.*)))::cardinal_number AS character_octet_length, (NULL::character varying)::sql_identifier AS character_set_catalog, (NULL::character varying)::sql_identifier AS character_set_schema, (NULL::character varying)::sql_identifier AS character_set_name, (NULL::character varying)::sql_identifier AS collation_catalog, (NULL::character varying)::sql_identifier AS collation_schema, (NULL::character varying)::sql_identifier AS collation_name, (_pg_numeric_precision(_pg_truetypid(a.*, t.*), _pg_truetypmod(a.*, t.*)))::cardinal_number AS numeric_precision, (_pg_numeric_precision_radix(_pg_truetypid(a.*, t.*), _pg_truetypmod(a.*, t.*)))::cardinal_number AS numeric_precision_radix, (_pg_numeric_scale(_pg_truetypid(a.*, t.*), _pg_truetypmod(a.*, t.*)))::cardinal_number AS numeric_scale, (_pg_datetime_precision(_pg_truetypid(a.*, t.*), _pg_truetypmod(a.*, t.*)))::cardinal_number AS datetime_precision, (NULL::character varying)::character_data AS interval_type, (NULL::character varying)::character_data AS interval_precision, (current_database())::sql_identifier AS attribute_udt_catalog, (nt.nspname)::sql_identifier AS attribute_udt_schema, (t.typname)::sql_identifier AS attribute_udt_name, (NULL::character varying)::sql_identifier AS scope_catalog, (NULL::character varying)::sql_identifier AS scope_schema, (NULL::character varying)::sql_identifier AS scope_name, (NULL::integer)::cardinal_number AS maximum_cardinality, (a.attnum)::sql_identifier AS dtd_identifier, ('NO'::character varying)::character_data AS is_derived_reference_attribute FROM (pg_attribute a LEFT JOIN pg_attrdef ad ON (((a.attrelid = ad.adrelid) AND (a.attnum = ad.adnum)))), pg_class c, pg_namespace nc, (pg_type t JOIN pg_namespace nt ON ((t.typnamespace = nt.oid))) WHERE ((((((a.attrelid = c.oid) AND (a.atttypid = t.oid)) AND (nc.oid = c.relnamespace)) AND (a.attnum > 0)) AND (NOT a.attisdropped)) AND (c.relkind = 'c'::"char"));


ALTER TABLE information_schema.attributes OWNER TO postgres;

See Also

List of views


View: check_constraint_routine_usage

Properties

Name: check_constraint_routine_usage 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 constraint_catalog sql_identifier -1 
 constraint_schema sql_identifier -1 
 constraint_name sql_identifier -1 
 specific_catalog sql_identifier -1 
 specific_schema sql_identifier -1 
 specific_name sql_identifier -1 
Total: 6 column(s)

SQL


CREATE VIEW check_constraint_routine_usage AS
    SELECT (current_database())::sql_identifier AS constraint_catalog, (nc.nspname)::sql_identifier AS constraint_schema, (c.conname)::sql_identifier AS constraint_name, (current_database())::sql_identifier AS specific_catalog, (np.nspname)::sql_identifier AS specific_schema, ((((p.proname)::text || '_'::text) || (p.oid)::text))::sql_identifier AS specific_name FROM pg_namespace nc, pg_constraint c, pg_depend d, pg_proc p, pg_namespace np WHERE ((((((((nc.oid = c.connamespace) AND (c.contype = 'c'::"char")) AND (c.oid = d.objid)) AND (d.classid = ('pg_constraint'::regclass)::oid)) AND (d.refobjid = p.oid)) AND (d.refclassid = ('pg_proc'::regclass)::oid)) AND (p.pronamespace = np.oid)) AND pg_has_role(p.proowner, 'USAGE'::text));


ALTER TABLE information_schema.check_constraint_routine_usage OWNER TO postgres;

See Also

List of views


View: check_constraints

Properties

Name: check_constraints 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 constraint_catalog varchar -1 
 constraint_schema varchar -1 
 constraint_name varchar -1 
 check_clause varchar -1 
Total: 4 column(s)

SQL


CREATE VIEW check_constraints AS
    SELECT (current_database())::sql_identifier AS constraint_catalog, (rs.nspname)::sql_identifier AS constraint_schema, (con.conname)::sql_identifier AS constraint_name, ("substring"(pg_get_constraintdef(con.oid), 7))::character_data AS check_clause FROM (((pg_constraint con LEFT JOIN pg_namespace rs ON ((rs.oid = con.connamespace))) LEFT JOIN pg_class c ON ((c.oid = con.conrelid))) LEFT JOIN pg_type t ON ((t.oid = con.contypid))) WHERE (pg_has_role(COALESCE(c.relowner, t.typowner), 'USAGE'::text) AND (con.contype = 'c'::"char")) UNION SELECT (current_database())::sql_identifier AS constraint_catalog, (n.nspname)::sql_identifier AS constraint_schema, (((((((n.oid)::text || '_'::text) || (r.oid)::text) || '_'::text) || (a.attnum)::text) || '_not_null'::text))::sql_identifier AS constraint_name, (((a.attname)::text || ' IS NOT NULL'::text))::character_data AS check_clause FROM pg_namespace n, pg_class r, pg_attribute a WHERE (((((((n.oid = r.relnamespace) AND (r.oid = a.attrelid)) AND (a.attnum > 0)) AND (NOT a.attisdropped)) AND a.attnotnull) AND (r.relkind = 'r'::"char")) AND pg_has_role(r.relowner, 'USAGE'::text));


ALTER TABLE information_schema.check_constraints OWNER TO postgres;

See Also

List of views


View: column_domain_usage

Properties

Name: column_domain_usage 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 domain_catalog sql_identifier -1 
 domain_schema sql_identifier -1 
 domain_name sql_identifier -1 
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 column_name sql_identifier -1 
Total: 7 column(s)

SQL


CREATE VIEW column_domain_usage AS
    SELECT (current_database())::sql_identifier AS domain_catalog, (nt.nspname)::sql_identifier AS domain_schema, (t.typname)::sql_identifier AS domain_name, (current_database())::sql_identifier AS table_catalog, (nc.nspname)::sql_identifier AS table_schema, (c.relname)::sql_identifier AS table_name, (a.attname)::sql_identifier AS column_name FROM pg_type t, pg_namespace nt, pg_class c, pg_namespace nc, pg_attribute a WHERE (((((((((t.typnamespace = nt.oid) AND (c.relnamespace = nc.oid)) AND (a.attrelid = c.oid)) AND (a.atttypid = t.oid)) AND (t.typtype = 'd'::"char")) AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND (a.attnum > 0)) AND (NOT a.attisdropped)) AND pg_has_role(t.typowner, 'USAGE'::text));


ALTER TABLE information_schema.column_domain_usage OWNER TO postgres;

See Also

List of views


View: column_privileges

Properties

Name: column_privileges 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 grantor sql_identifier -1 
 grantee sql_identifier -1 
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 column_name sql_identifier -1 
 privilege_type character_data -1 
 is_grantable character_data -1 
Total: 8 column(s)

SQL


CREATE VIEW column_privileges AS
    SELECT (u_grantor.rolname)::sql_identifier AS grantor, (grantee.rolname)::sql_identifier AS grantee, (current_database())::sql_identifier AS table_catalog, (nc.nspname)::sql_identifier AS table_schema, (c.relname)::sql_identifier AS table_name, (a.attname)::sql_identifier AS column_name, (pr."type")::character_data AS privilege_type, (CASE WHEN aclcontains(c.relacl, makeaclitem(grantee.oid, u_grantor.oid, pr."type", true)) THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_grantable FROM pg_attribute a, pg_class c, pg_namespace nc, pg_authid u_grantor, (SELECT pg_authid.oid, pg_authid.rolname FROM pg_authid UNION ALL SELECT (0)::oid AS oid, 'PUBLIC') grantee(oid, rolname), (((SELECT 'SELECT' UNION ALL SELECT 'INSERT') UNION ALL SELECT 'UPDATE') UNION ALL SELECT 'REFERENCES') pr("type") WHERE (((((((a.attrelid = c.oid) AND (c.relnamespace = nc.oid)) AND (a.attnum > 0)) AND (NOT a.attisdropped)) AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND aclcontains(c.relacl, makeaclitem(grantee.oid, u_grantor.oid, pr."type", false))) AND ((pg_has_role(u_grantor.oid, 'USAGE'::text) OR pg_has_role(grantee.oid, 'USAGE'::text)) OR (grantee.rolname = 'PUBLIC'::name)));


ALTER TABLE information_schema.column_privileges OWNER TO postgres;

See Also

List of views


View: column_udt_usage

Properties

Name: column_udt_usage 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 udt_catalog sql_identifier -1 
 udt_schema sql_identifier -1 
 udt_name sql_identifier -1 
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 column_name sql_identifier -1 
Total: 7 column(s)

SQL


CREATE VIEW column_udt_usage AS
    SELECT (current_database())::sql_identifier AS udt_catalog, (COALESCE(nbt.nspname, nt.nspname))::sql_identifier AS udt_schema, (COALESCE(bt.typname, t.typname))::sql_identifier AS udt_name, (current_database())::sql_identifier AS table_catalog, (nc.nspname)::sql_identifier AS table_schema, (c.relname)::sql_identifier AS table_name, (a.attname)::sql_identifier AS column_name FROM pg_attribute a, pg_class c, pg_namespace nc, ((pg_type t JOIN pg_namespace nt ON ((t.typnamespace = nt.oid))) LEFT JOIN (pg_type bt JOIN pg_namespace nbt ON ((bt.typnamespace = nbt.oid))) ON (((t.typtype = 'd'::"char") AND (t.typbasetype = bt.oid)))) WHERE (((((((a.attrelid = c.oid) AND (a.atttypid = t.oid)) AND (nc.oid = c.relnamespace)) AND (a.attnum > 0)) AND (NOT a.attisdropped)) AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND pg_has_role(COALESCE(bt.typowner, t.typowner), 'USAGE'::text));


ALTER TABLE information_schema.column_udt_usage OWNER TO postgres;

See Also

List of views


View: columns

Properties

Name: columns 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 column_name sql_identifier -1 
 ordinal_position cardinal_number -1 
 column_default character_data -1 
 is_nullable character_data -1 
 data_type character_data -1 
 character_maximum_length cardinal_number -1 
 character_octet_length cardinal_number -1 
 numeric_precision cardinal_number -1 
 numeric_precision_radix cardinal_number -1 
 numeric_scale cardinal_number -1 
 datetime_precision cardinal_number -1 
 interval_type character_data -1 
 interval_precision character_data -1 
 character_set_catalog sql_identifier -1 
 character_set_schema sql_identifier -1 
 character_set_name sql_identifier -1 
 collation_catalog sql_identifier -1 
 collation_schema sql_identifier -1 
 collation_name sql_identifier -1 
 domain_catalog sql_identifier -1 
 domain_schema sql_identifier -1 
 domain_name sql_identifier -1 
 udt_catalog sql_identifier -1 
 udt_schema sql_identifier -1 
 udt_name sql_identifier -1 
 scope_catalog sql_identifier -1 
 scope_schema sql_identifier -1 
 scope_name sql_identifier -1 
 maximum_cardinality cardinal_number -1 
 dtd_identifier sql_identifier -1 
 is_self_referencing character_data -1 
 is_identity character_data -1 
 identity_generation character_data -1 
 identity_start character_data -1 
 identity_increment character_data -1 
 identity_maximum character_data -1 
 identity_minimum character_data -1 
 identity_cycle character_data -1 
 is_generated character_data -1 
 generation_expression character_data -1 
 is_updatable character_data -1 
Total: 44 column(s)

SQL


CREATE VIEW columns AS
    SELECT (current_database())::sql_identifier AS table_catalog, (nc.nspname)::sql_identifier AS table_schema, (c.relname)::sql_identifier AS table_name, (a.attname)::sql_identifier AS column_name, (a.attnum)::cardinal_number AS ordinal_position, (pg_get_expr(ad.adbin, ad.adrelid))::character_data AS column_default, (CASE WHEN (a.attnotnull OR ((t.typtype = 'd'::"char") AND t.typnotnull)) THEN 'NO'::text ELSE 'YES'::text END)::character_data AS is_nullable, (CASE WHEN (t.typtype = 'd'::"char") THEN CASE WHEN ((bt.typelem <> (0)::oid) AND (bt.typlen = -1)) THEN 'ARRAY'::text WHEN (nbt.nspname = 'pg_catalog'::name) THEN format_type(t.typbasetype, NULL::integer) ELSE 'USER-DEFINED'::text END ELSE CASE WHEN ((t.typelem <> (0)::oid) AND (t.typlen = -1)) THEN 'ARRAY'::text WHEN (nt.nspname = 'pg_catalog'::name) THEN format_type(a.atttypid, NULL::integer) ELSE 'USER-DEFINED'::text END END)::character_data AS data_type, (_pg_char_max_length(_pg_truetypid(a.*, t.*), _pg_truetypmod(a.*, t.*)))::cardinal_number AS character_maximum_length, (_pg_char_octet_length(_pg_truetypid(a.*, t.*), _pg_truetypmod(a.*, t.*)))::cardinal_number AS character_octet_length, (_pg_numeric_precision(_pg_truetypid(a.*, t.*), _pg_truetypmod(a.*, t.*)))::cardinal_number AS numeric_precision, (_pg_numeric_precision_radix(_pg_truetypid(a.*, t.*), _pg_truetypmod(a.*, t.*)))::cardinal_number AS numeric_precision_radix, (_pg_numeric_scale(_pg_truetypid(a.*, t.*), _pg_truetypmod(a.*, t.*)))::cardinal_number AS numeric_scale, (_pg_datetime_precision(_pg_truetypid(a.*, t.*), _pg_truetypmod(a.*, t.*)))::cardinal_number AS datetime_precision, (NULL::character varying)::character_data AS interval_type, (NULL::character varying)::character_data AS interval_precision, (NULL::character varying)::sql_identifier AS character_set_catalog, (NULL::character varying)::sql_identifier AS character_set_schema, (NULL::character varying)::sql_identifier AS character_set_name, (NULL::character varying)::sql_identifier AS collation_catalog, (NULL::character varying)::sql_identifier AS collation_schema, (NULL::character varying)::sql_identifier AS collation_name, (CASE WHEN (t.typtype = 'd'::"char") THEN current_database() ELSE NULL::name END)::sql_identifier AS domain_catalog, (CASE WHEN (t.typtype = 'd'::"char") THEN nt.nspname ELSE NULL::name END)::sql_identifier AS domain_schema, (CASE WHEN (t.typtype = 'd'::"char") THEN t.typname ELSE NULL::name END)::sql_identifier AS domain_name, (current_database())::sql_identifier AS udt_catalog, (COALESCE(nbt.nspname, nt.nspname))::sql_identifier AS udt_schema, (COALESCE(bt.typname, t.typname))::sql_identifier AS udt_name, (NULL::character varying)::sql_identifier AS scope_catalog, (NULL::character varying)::sql_identifier AS scope_schema, (NULL::character varying)::sql_identifier AS scope_name, (NULL::integer)::cardinal_number AS maximum_cardinality, (a.attnum)::sql_identifier AS dtd_identifier, ('NO'::character varying)::character_data AS is_self_referencing, ('NO'::character varying)::character_data AS is_identity, (NULL::character varying)::character_data AS identity_generation, (NULL::character varying)::character_data AS identity_start, (NULL::character varying)::character_data AS identity_increment, (NULL::character varying)::character_data AS identity_maximum, (NULL::character varying)::character_data AS identity_minimum, (NULL::character varying)::character_data AS identity_cycle, ('NEVER'::character varying)::character_data AS is_generated, (NULL::character varying)::character_data AS generation_expression, (CASE WHEN (c.relkind = 'r'::"char") THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_updatable FROM (pg_attribute a LEFT JOIN pg_attrdef ad ON (((a.attrelid = ad.adrelid) AND (a.attnum = ad.adnum)))), pg_class c, pg_namespace nc, ((pg_type t JOIN pg_namespace nt ON ((t.typnamespace = nt.oid))) LEFT JOIN (pg_type bt JOIN pg_namespace nbt ON ((bt.typnamespace = nbt.oid))) ON (((t.typtype = 'd'::"char") AND (t.typbasetype = bt.oid)))) WHERE ((((((((a.attrelid = c.oid) AND (a.atttypid = t.oid)) AND (nc.oid = c.relnamespace)) AND (NOT pg_is_other_temp_schema(nc.oid))) AND (a.attnum > 0)) AND (NOT a.attisdropped)) AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND ((((pg_has_role(c.relowner, 'USAGE'::text) OR has_table_privilege(c.oid, 'SELECT'::text)) OR has_table_privilege(c.oid, 'INSERT'::text)) OR has_table_privilege(c.oid, 'UPDATE'::text)) OR has_table_privilege(c.oid, 'REFERENCES'::text)));


ALTER TABLE information_schema.columns OWNER TO postgres;

See Also

List of views


View: constraint_column_usage

Properties

Name: constraint_column_usage 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 column_name sql_identifier -1 
 constraint_catalog sql_identifier -1 
 constraint_schema sql_identifier -1 
 constraint_name sql_identifier -1 
Total: 7 column(s)

SQL


CREATE VIEW constraint_column_usage AS
    SELECT (current_database())::sql_identifier AS table_catalog, (x.tblschema)::sql_identifier AS table_schema, (x.tblname)::sql_identifier AS table_name, (x.colname)::sql_identifier AS column_name, (current_database())::sql_identifier AS constraint_catalog, (x.cstrschema)::sql_identifier AS constraint_schema, (x.cstrname)::sql_identifier AS constraint_name FROM ((SELECT DISTINCT nr.nspname, r.relname, r.relowner, a.attname, nc.nspname, c.conname FROM pg_namespace nr, pg_class r, pg_attribute a, pg_depend d, pg_namespace nc, pg_constraint c WHERE (((((((((((nr.oid = r.relnamespace) AND (r.oid = a.attrelid)) AND (d.refclassid = ('pg_class'::regclass)::oid)) AND (d.refobjid = r.oid)) AND (d.refobjsubid = a.attnum)) AND (d.classid = ('pg_constraint'::regclass)::oid)) AND (d.objid = c.oid)) AND (c.connamespace = nc.oid)) AND (c.contype = 'c'::"char")) AND (r.relkind = 'r'::"char")) AND (NOT a.attisdropped)) ORDER BY nr.nspname, r.relname, r.relowner, a.attname, nc.nspname, c.conname) UNION ALL SELECT nr.nspname, r.relname, r.relowner, a.attname, nc.nspname, c.conname FROM pg_namespace nr, pg_class r, pg_attribute a, pg_namespace nc, pg_constraint c WHERE (((((((nr.oid = r.relnamespace) AND (r.oid = a.attrelid)) AND (nc.oid = c.connamespace)) AND CASE WHEN (c.contype = 'f'::"char") THEN ((r.oid = c.confrelid) AND (a.attnum = ANY (c.confkey))) ELSE ((r.oid = c.conrelid) AND (a.attnum = ANY (c.conkey))) END) AND (NOT a.attisdropped)) AND (c.contype = ANY (ARRAY['p'::"char", 'u'::"char", 'f'::"char"]))) AND (r.relkind = 'r'::"char"))) x(tblschema, tblname, tblowner, colname, cstrschema, cstrname) WHERE pg_has_role(x.tblowner, 'USAGE'::text);


ALTER TABLE information_schema.constraint_column_usage OWNER TO postgres;

See Also

List of views


View: constraint_table_usage

Properties

Name: constraint_table_usage 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 constraint_catalog sql_identifier -1 
 constraint_schema sql_identifier -1 
 constraint_name sql_identifier -1 
Total: 6 column(s)

SQL


CREATE VIEW constraint_table_usage AS
    SELECT (current_database())::sql_identifier AS table_catalog, (nr.nspname)::sql_identifier AS table_schema, (r.relname)::sql_identifier AS table_name, (current_database())::sql_identifier AS constraint_catalog, (nc.nspname)::sql_identifier AS constraint_schema, (c.conname)::sql_identifier AS constraint_name FROM pg_constraint c, pg_namespace nc, pg_class r, pg_namespace nr WHERE (((((c.connamespace = nc.oid) AND (r.relnamespace = nr.oid)) AND (((c.contype = 'f'::"char") AND (c.confrelid = r.oid)) OR ((c.contype = ANY (ARRAY['p'::"char", 'u'::"char"])) AND (c.conrelid = r.oid)))) AND (r.relkind = 'r'::"char")) AND pg_has_role(r.relowner, 'USAGE'::text));


ALTER TABLE information_schema.constraint_table_usage OWNER TO postgres;

See Also

List of views


View: data_type_privileges

Properties

Name: data_type_privileges 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 object_catalog sql_identifier -1 
 object_schema sql_identifier -1 
 object_name sql_identifier -1 
 object_type character_data -1 
 dtd_identifier sql_identifier -1 
Total: 5 column(s)

SQL


CREATE VIEW data_type_privileges AS
    SELECT (current_database())::sql_identifier AS object_catalog, (x.objschema)::sql_identifier AS object_schema, (x.objname)::sql_identifier AS object_name, (x.objtype)::character_data AS object_type, (x.objdtdid)::sql_identifier AS dtd_identifier FROM ((((SELECT attributes.udt_schema, attributes.udt_name, 'USER-DEFINED TYPE'::text AS text, attributes.dtd_identifier FROM attributes UNION ALL SELECT columns.table_schema, columns.table_name, 'TABLE'::text AS text, columns.dtd_identifier FROM columns) UNION ALL SELECT domains.domain_schema, domains.domain_name, 'DOMAIN'::text AS text, domains.dtd_identifier FROM domains) UNION ALL SELECT parameters.specific_schema, parameters.specific_name, 'ROUTINE'::text AS text, parameters.dtd_identifier FROM parameters) UNION ALL SELECT routines.specific_schema, routines.specific_name, 'ROUTINE'::text AS text, routines.dtd_identifier FROM routines) x(objschema, objname, objtype, objdtdid);


ALTER TABLE information_schema.data_type_privileges OWNER TO postgres;

See Also

List of views


View: domain_constraints

Properties

Name: domain_constraints 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 constraint_catalog sql_identifier -1 
 constraint_schema sql_identifier -1 
 constraint_name sql_identifier -1 
 domain_catalog sql_identifier -1 
 domain_schema sql_identifier -1 
 domain_name sql_identifier -1 
 is_deferrable character_data -1 
 initially_deferred character_data -1 
Total: 8 column(s)

SQL


CREATE VIEW domain_constraints AS
    SELECT (current_database())::sql_identifier AS constraint_catalog, (rs.nspname)::sql_identifier AS constraint_schema, (con.conname)::sql_identifier AS constraint_name, (current_database())::sql_identifier AS domain_catalog, (n.nspname)::sql_identifier AS domain_schema, (t.typname)::sql_identifier AS domain_name, (CASE WHEN con.condeferrable THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_deferrable, (CASE WHEN con.condeferred THEN 'YES'::text ELSE 'NO'::text END)::character_data AS initially_deferred FROM pg_namespace rs, pg_namespace n, pg_constraint con, pg_type t WHERE (((rs.oid = con.connamespace) AND (n.oid = t.typnamespace)) AND (t.oid = con.contypid));


ALTER TABLE information_schema.domain_constraints OWNER TO postgres;

See Also

List of views


View: domain_udt_usage

Properties

Name: domain_udt_usage 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 udt_catalog sql_identifier -1 
 udt_schema sql_identifier -1 
 udt_name sql_identifier -1 
 domain_catalog sql_identifier -1 
 domain_schema sql_identifier -1 
 domain_name sql_identifier -1 
Total: 6 column(s)

SQL


CREATE VIEW domain_udt_usage AS
    SELECT (current_database())::sql_identifier AS udt_catalog, (nbt.nspname)::sql_identifier AS udt_schema, (bt.typname)::sql_identifier AS udt_name, (current_database())::sql_identifier AS domain_catalog, (nt.nspname)::sql_identifier AS domain_schema, (t.typname)::sql_identifier AS domain_name FROM pg_type t, pg_namespace nt, pg_type bt, pg_namespace nbt WHERE (((((t.typnamespace = nt.oid) AND (t.typbasetype = bt.oid)) AND (bt.typnamespace = nbt.oid)) AND (t.typtype = 'd'::"char")) AND pg_has_role(bt.typowner, 'USAGE'::text));


ALTER TABLE information_schema.domain_udt_usage OWNER TO postgres;

See Also

List of views


View: domains

Properties

Name: domains 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 domain_catalog sql_identifier -1 
 domain_schema sql_identifier -1 
 domain_name sql_identifier -1 
 data_type character_data -1 
 character_maximum_length cardinal_number -1 
 character_octet_length cardinal_number -1 
 character_set_catalog sql_identifier -1 
 character_set_schema sql_identifier -1 
 character_set_name sql_identifier -1 
 collation_catalog sql_identifier -1 
 collation_schema sql_identifier -1 
 collation_name sql_identifier -1 
 numeric_precision cardinal_number -1 
 numeric_precision_radix cardinal_number -1 
 numeric_scale cardinal_number -1 
 datetime_precision cardinal_number -1 
 interval_type character_data -1 
 interval_precision character_data -1 
 domain_default character_data -1 
 udt_catalog sql_identifier -1 
 udt_schema sql_identifier -1 
 udt_name sql_identifier -1 
 scope_catalog sql_identifier -1 
 scope_schema sql_identifier -1 
 scope_name sql_identifier -1 
 maximum_cardinality cardinal_number -1 
 dtd_identifier sql_identifier -1 
Total: 27 column(s)

SQL


CREATE VIEW domains AS
    SELECT (current_database())::sql_identifier AS domain_catalog, (nt.nspname)::sql_identifier AS domain_schema, (t.typname)::sql_identifier AS domain_name, (CASE WHEN ((t.typelem <> (0)::oid) AND (t.typlen = -1)) THEN 'ARRAY'::text WHEN (nbt.nspname = 'pg_catalog'::name) THEN format_type(t.typbasetype, NULL::integer) ELSE 'USER-DEFINED'::text END)::character_data AS data_type, (_pg_char_max_length(t.typbasetype, t.typtypmod))::cardinal_number AS character_maximum_length, (_pg_char_octet_length(t.typbasetype, t.typtypmod))::cardinal_number AS character_octet_length, (NULL::character varying)::sql_identifier AS character_set_catalog, (NULL::character varying)::sql_identifier AS character_set_schema, (NULL::character varying)::sql_identifier AS character_set_name, (NULL::character varying)::sql_identifier AS collation_catalog, (NULL::character varying)::sql_identifier AS collation_schema, (NULL::character varying)::sql_identifier AS collation_name, (_pg_numeric_precision(t.typbasetype, t.typtypmod))::cardinal_number AS numeric_precision, (_pg_numeric_precision_radix(t.typbasetype, t.typtypmod))::cardinal_number AS numeric_precision_radix, (_pg_numeric_scale(t.typbasetype, t.typtypmod))::cardinal_number AS numeric_scale, (_pg_datetime_precision(t.typbasetype, t.typtypmod))::cardinal_number AS datetime_precision, (NULL::character varying)::character_data AS interval_type, (NULL::character varying)::character_data AS interval_precision, (t.typdefault)::character_data AS domain_default, (current_database())::sql_identifier AS udt_catalog, (nbt.nspname)::sql_identifier AS udt_schema, (bt.typname)::sql_identifier AS udt_name, (NULL::character varying)::sql_identifier AS scope_catalog, (NULL::character varying)::sql_identifier AS scope_schema, (NULL::character varying)::sql_identifier AS scope_name, (NULL::integer)::cardinal_number AS maximum_cardinality, (1)::sql_identifier AS dtd_identifier FROM pg_type t, pg_namespace nt, pg_type bt, pg_namespace nbt WHERE ((((t.typnamespace = nt.oid) AND (t.typbasetype = bt.oid)) AND (bt.typnamespace = nbt.oid)) AND (t.typtype = 'd'::"char"));


ALTER TABLE information_schema.domains OWNER TO postgres;

See Also

List of views


View: element_types

Properties

Name: element_types 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 object_catalog sql_identifier -1 
 object_schema sql_identifier -1 
 object_name sql_identifier -1 
 object_type character_data -1 
 collection_type_identifier sql_identifier -1 
 data_type character_data -1 
 character_maximum_length cardinal_number -1 
 character_octet_length cardinal_number -1 
 character_set_catalog sql_identifier -1 
 character_set_schema sql_identifier -1 
 character_set_name sql_identifier -1 
 collation_catalog sql_identifier -1 
 collation_schema sql_identifier -1 
 collation_name sql_identifier -1 
 numeric_precision cardinal_number -1 
 numeric_precision_radix cardinal_number -1 
 numeric_scale cardinal_number -1 
 datetime_precision cardinal_number -1 
 interval_type character_data -1 
 interval_precision character_data -1 
 domain_default character_data -1 
 udt_catalog sql_identifier -1 
 udt_schema sql_identifier -1 
 udt_name sql_identifier -1 
 scope_catalog sql_identifier -1 
 scope_schema sql_identifier -1 
 scope_name sql_identifier -1 
 maximum_cardinality cardinal_number -1 
 dtd_identifier sql_identifier -1 
Total: 29 column(s)

SQL


CREATE VIEW element_types AS
    SELECT (current_database())::sql_identifier AS object_catalog, (n.nspname)::sql_identifier AS object_schema, (x.objname)::sql_identifier AS object_name, (x.objtype)::character_data AS object_type, (x.objdtdid)::sql_identifier AS collection_type_identifier, (CASE WHEN (nbt.nspname = 'pg_catalog'::name) THEN format_type(bt.oid, NULL::integer) ELSE 'USER-DEFINED'::text END)::character_data AS data_type, (NULL::integer)::cardinal_number AS character_maximum_length, (NULL::integer)::cardinal_number AS character_octet_length, (NULL::character varying)::sql_identifier AS character_set_catalog, (NULL::character varying)::sql_identifier AS character_set_schema, (NULL::character varying)::sql_identifier AS character_set_name, (NULL::character varying)::sql_identifier AS collation_catalog, (NULL::character varying)::sql_identifier AS collation_schema, (NULL::character varying)::sql_identifier AS collation_name, (NULL::integer)::cardinal_number AS numeric_precision, (NULL::integer)::cardinal_number AS numeric_precision_radix, (NULL::integer)::cardinal_number AS numeric_scale, (NULL::integer)::cardinal_number AS datetime_precision, (NULL::character varying)::character_data AS interval_type, (NULL::character varying)::character_data AS interval_precision, (NULL::character varying)::character_data AS domain_default, (current_database())::sql_identifier AS udt_catalog, (nbt.nspname)::sql_identifier AS udt_schema, (bt.typname)::sql_identifier AS udt_name, (NULL::character varying)::sql_identifier AS scope_catalog, (NULL::character varying)::sql_identifier AS scope_schema, (NULL::character varying)::sql_identifier AS scope_name, (NULL::integer)::cardinal_number AS maximum_cardinality, (('a'::text || (x.objdtdid)::text))::sql_identifier AS dtd_identifier FROM pg_namespace n, pg_type "at", pg_namespace nbt, pg_type bt, (((SELECT c.relnamespace, (c.relname)::sql_identifier AS relname, 'TABLE'::text AS text, a.attnum, a.atttypid FROM pg_class c, pg_attribute a WHERE ((((c.oid = a.attrelid) AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND (a.attnum > 0)) AND (NOT a.attisdropped)) UNION ALL SELECT t.typnamespace, (t.typname)::sql_identifier AS typname, 'DOMAIN'::text AS text, 1, t.typbasetype FROM pg_type t WHERE (t.typtype = 'd'::"char")) UNION ALL SELECT ss.pronamespace, ((((ss.proname)::text || '_'::text) || (ss.oid)::text))::sql_identifier AS sql_identifier, 'ROUTINE'::text AS text, (ss.x).n AS n, (ss.x).x AS x FROM (SELECT p.pronamespace, p.proname, p.oid, _pg_expandarray(COALESCE(p.proallargtypes, (p.proargtypes)::oid[])) AS x FROM pg_proc p) ss) UNION ALL SELECT p.pronamespace, ((((p.proname)::text || '_'::text) || (p.oid)::text))::sql_identifier AS sql_identifier, 'ROUTINE'::text AS text, 0, p.prorettype FROM pg_proc p) x(objschema, objname, objtype, objdtdid, objtypeid) WHERE ((((((n.oid = x.objschema) AND ("at".oid = x.objtypeid)) AND (("at".typelem <> (0)::oid) AND ("at".typlen = -1))) AND ("at".typelem = bt.oid)) AND (nbt.oid = bt.typnamespace)) AND ((n.nspname, (x.objname)::text, x.objtype, (x.objdtdid)::text) IN (SELECT data_type_privileges.object_schema, data_type_privileges.object_name, data_type_privileges.object_type, data_type_privileges.dtd_identifier FROM data_type_privileges)));


ALTER TABLE information_schema.element_types OWNER TO postgres;

See Also

List of views


View: enabled_roles

Properties

Name: enabled_roles 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 role_name sql_identifier -1 
Total: 1 column(s)

SQL


CREATE VIEW enabled_roles AS
    SELECT (a.rolname)::sql_identifier AS role_name FROM pg_authid a WHERE pg_has_role(a.oid, 'USAGE'::text);


ALTER TABLE information_schema.enabled_roles OWNER TO postgres;

See Also

List of views


View: information_schema_catalog_name

Properties

Name: information_schema_catalog_name 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 catalog_name sql_identifier -1 
Total: 1 column(s)

SQL


CREATE VIEW information_schema_catalog_name AS
    SELECT (current_database())::sql_identifier AS catalog_name;


ALTER TABLE information_schema.information_schema_catalog_name OWNER TO postgres;

See Also

List of views


View: key_column_usage

Properties

Name: key_column_usage 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 constraint_catalog sql_identifier -1 
 constraint_schema sql_identifier -1 
 constraint_name sql_identifier -1 
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 column_name sql_identifier -1 
 ordinal_position cardinal_number -1 
 position_in_unique_constraint cardinal_number -1 
Total: 9 column(s)

SQL


CREATE VIEW key_column_usage AS
    SELECT (current_database())::sql_identifier AS constraint_catalog, (ss.nc_nspname)::sql_identifier AS constraint_schema, (ss.conname)::sql_identifier AS constraint_name, (current_database())::sql_identifier AS table_catalog, (ss.nr_nspname)::sql_identifier AS table_schema, (ss.relname)::sql_identifier AS table_name, (a.attname)::sql_identifier AS column_name, ((ss.x).n)::cardinal_number AS ordinal_position, (CASE WHEN (ss.contype = 'f'::"char") THEN _pg_index_position(_pg_underlying_index(ss.coid), ss.confkey[(ss.x).n]) ELSE NULL::integer END)::cardinal_number AS position_in_unique_constraint FROM pg_attribute a, (SELECT r.oid AS roid, r.relname, nc.nspname AS nc_nspname, nr.nspname AS nr_nspname, c.oid AS coid, c.conname, c.contype, c.confkey, c.confrelid, _pg_expandarray(c.conkey) AS x FROM pg_namespace nr, pg_class r, pg_namespace nc, pg_constraint c WHERE (((((((nr.oid = r.relnamespace) AND (r.oid = c.conrelid)) AND (nc.oid = c.connamespace)) AND (c.contype = ANY (ARRAY['p'::"char", 'u'::"char", 'f'::"char"]))) AND (r.relkind = 'r'::"char")) AND (NOT pg_is_other_temp_schema(nr.oid))) AND ((((pg_has_role(r.relowner, 'USAGE'::text) OR has_table_privilege(r.oid, 'SELECT'::text)) OR has_table_privilege(r.oid, 'INSERT'::text)) OR has_table_privilege(r.oid, 'UPDATE'::text)) OR has_table_privilege(r.oid, 'REFERENCES'::text)))) ss WHERE (((ss.roid = a.attrelid) AND (a.attnum = (ss.x).x)) AND (NOT a.attisdropped));


ALTER TABLE information_schema.key_column_usage OWNER TO postgres;

See Also

List of views


View: parameters

Properties

Name: parameters 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 specific_catalog sql_identifier -1 
 specific_schema sql_identifier -1 
 specific_name sql_identifier -1 
 ordinal_position cardinal_number -1 
 parameter_mode character_data -1 
 is_result character_data -1 
 as_locator character_data -1 
 parameter_name sql_identifier -1 
 data_type character_data -1 
 character_maximum_length cardinal_number -1 
 character_octet_length cardinal_number -1 
 character_set_catalog sql_identifier -1 
 character_set_schema sql_identifier -1 
 character_set_name sql_identifier -1 
 collation_catalog sql_identifier -1 
 collation_schema sql_identifier -1 
 collation_name sql_identifier -1 
 numeric_precision cardinal_number -1 
 numeric_precision_radix cardinal_number -1 
 numeric_scale cardinal_number -1 
 datetime_precision cardinal_number -1 
 interval_type character_data -1 
 interval_precision character_data -1 
 udt_catalog sql_identifier -1 
 udt_schema sql_identifier -1 
 udt_name sql_identifier -1 
 scope_catalog sql_identifier -1 
 scope_schema sql_identifier -1 
 scope_name sql_identifier -1 
 maximum_cardinality cardinal_number -1 
 dtd_identifier sql_identifier -1 
Total: 31 column(s)

SQL


CREATE VIEW parameters AS
    SELECT (current_database())::sql_identifier AS specific_catalog, (ss.n_nspname)::sql_identifier AS specific_schema, ((((ss.proname)::text || '_'::text) || (ss.p_oid)::text))::sql_identifier AS specific_name, ((ss.x).n)::cardinal_number AS ordinal_position, (CASE WHEN (ss.proargmodes IS NULL) THEN 'IN'::text WHEN (ss.proargmodes[(ss.x).n] = 'i'::"char") THEN 'IN'::text WHEN (ss.proargmodes[(ss.x).n] = 'o'::"char") THEN 'OUT'::text WHEN (ss.proargmodes[(ss.x).n] = 'b'::"char") THEN 'INOUT'::text ELSE NULL::text END)::character_data AS parameter_mode, ('NO'::character varying)::character_data AS is_result, ('NO'::character varying)::character_data AS as_locator, (NULLIF(ss.proargnames[(ss.x).n], ''::text))::sql_identifier AS parameter_name, (CASE WHEN ((t.typelem <> (0)::oid) AND (t.typlen = -1)) THEN 'ARRAY'::text WHEN (nt.nspname = 'pg_catalog'::name) THEN format_type(t.oid, NULL::integer) ELSE 'USER-DEFINED'::text END)::character_data AS data_type, (NULL::integer)::cardinal_number AS character_maximum_length, (NULL::integer)::cardinal_number AS character_octet_length, (NULL::character varying)::sql_identifier AS character_set_catalog, (NULL::character varying)::sql_identifier AS character_set_schema, (NULL::character varying)::sql_identifier AS character_set_name, (NULL::character varying)::sql_identifier AS collation_catalog, (NULL::character varying)::sql_identifier AS collation_schema, (NULL::character varying)::sql_identifier AS collation_name, (NULL::integer)::cardinal_number AS numeric_precision, (NULL::integer)::cardinal_number AS numeric_precision_radix, (NULL::integer)::cardinal_number AS numeric_scale, (NULL::integer)::cardinal_number AS datetime_precision, (NULL::character varying)::character_data AS interval_type, (NULL::character varying)::character_data AS interval_precision, (current_database())::sql_identifier AS udt_catalog, (nt.nspname)::sql_identifier AS udt_schema, (t.typname)::sql_identifier AS udt_name, (NULL::character varying)::sql_identifier AS scope_catalog, (NULL::character varying)::sql_identifier AS scope_schema, (NULL::character varying)::sql_identifier AS scope_name, (NULL::integer)::cardinal_number AS maximum_cardinality, ((ss.x).n)::sql_identifier AS dtd_identifier FROM pg_type t, pg_namespace nt, (SELECT n.nspname AS n_nspname, p.proname, p.oid AS p_oid, p.proargnames, p.proargmodes, _pg_expandarray(COALESCE(p.proallargtypes, (p.proargtypes)::oid[])) AS x FROM pg_namespace n, pg_proc p WHERE ((n.oid = p.pronamespace) AND (pg_has_role(p.proowner, 'USAGE'::text) OR has_function_privilege(p.oid, 'EXECUTE'::text)))) ss WHERE ((t.oid = (ss.x).x) AND (t.typnamespace = nt.oid));


ALTER TABLE information_schema.parameters OWNER TO postgres;

See Also

List of views


View: referential_constraints

Properties

Name: referential_constraints 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 constraint_catalog sql_identifier -1 
 constraint_schema sql_identifier -1 
 constraint_name sql_identifier -1 
 unique_constraint_catalog sql_identifier -1 
 unique_constraint_schema sql_identifier -1 
 unique_constraint_name sql_identifier -1 
 match_option character_data -1 
 update_rule character_data -1 
 delete_rule character_data -1 
Total: 9 column(s)

SQL


CREATE VIEW referential_constraints AS
    SELECT (current_database())::sql_identifier AS constraint_catalog, (ncon.nspname)::sql_identifier AS constraint_schema, (con.conname)::sql_identifier AS constraint_name, (CASE WHEN (npkc.nspname IS NULL) THEN NULL::name ELSE current_database() END)::sql_identifier AS unique_constraint_catalog, (npkc.nspname)::sql_identifier AS unique_constraint_schema, (pkc.conname)::sql_identifier AS unique_constraint_name, (CASE con.confmatchtype WHEN 'f'::"char" THEN 'FULL'::text WHEN 'p'::"char" THEN 'PARTIAL'::text WHEN 'u'::"char" THEN 'NONE'::text ELSE NULL::text END)::character_data AS match_option, (CASE con.confupdtype WHEN 'c'::"char" THEN 'CASCADE'::text WHEN 'n'::"char" THEN 'SET NULL'::text WHEN 'd'::"char" THEN 'SET DEFAULT'::text WHEN 'r'::"char" THEN 'RESTRICT'::text WHEN 'a'::"char" THEN 'NO ACTION'::text ELSE NULL::text END)::character_data AS update_rule, (CASE con.confdeltype WHEN 'c'::"char" THEN 'CASCADE'::text WHEN 'n'::"char" THEN 'SET NULL'::text WHEN 'd'::"char" THEN 'SET DEFAULT'::text WHEN 'r'::"char" THEN 'RESTRICT'::text WHEN 'a'::"char" THEN 'NO ACTION'::text ELSE NULL::text END)::character_data AS delete_rule FROM (((pg_namespace ncon JOIN pg_constraint con ON ((ncon.oid = con.connamespace))) JOIN pg_class c ON ((con.conrelid = c.oid))) LEFT JOIN (pg_constraint pkc JOIN pg_namespace npkc ON ((pkc.connamespace = npkc.oid))) ON (((con.confrelid = pkc.conrelid) AND _pg_keysequal(con.confkey, pkc.conkey)))) WHERE ((((c.relkind = 'r'::"char") AND (con.contype = 'f'::"char")) AND ((pkc.contype = ANY (ARRAY['p'::"char", 'u'::"char"])) OR (pkc.contype IS NULL))) AND pg_has_role(c.relowner, 'USAGE'::text));


ALTER TABLE information_schema.referential_constraints OWNER TO postgres;

See Also

List of views


View: role_column_grants

Properties

Name: role_column_grants 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 grantor sql_identifier -1 
 grantee sql_identifier -1 
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 column_name sql_identifier -1 
 privilege_type character_data -1 
 is_grantable character_data -1 
Total: 8 column(s)

SQL


CREATE VIEW role_column_grants AS
    SELECT (u_grantor.rolname)::sql_identifier AS grantor, (g_grantee.rolname)::sql_identifier AS grantee, (current_database())::sql_identifier AS table_catalog, (nc.nspname)::sql_identifier AS table_schema, (c.relname)::sql_identifier AS table_name, (a.attname)::sql_identifier AS column_name, (pr."type")::character_data AS privilege_type, (CASE WHEN aclcontains(c.relacl, makeaclitem(g_grantee.oid, u_grantor.oid, pr."type", true)) THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_grantable FROM pg_attribute a, pg_class c, pg_namespace nc, pg_authid u_grantor, pg_authid g_grantee, (((SELECT 'SELECT' UNION ALL SELECT 'INSERT') UNION ALL SELECT 'UPDATE') UNION ALL SELECT 'REFERENCES') pr("type") WHERE (((((((a.attrelid = c.oid) AND (c.relnamespace = nc.oid)) AND (a.attnum > 0)) AND (NOT a.attisdropped)) AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND aclcontains(c.relacl, makeaclitem(g_grantee.oid, u_grantor.oid, pr."type", false))) AND ((u_grantor.rolname IN (SELECT enabled_roles.role_name FROM enabled_roles)) OR (g_grantee.rolname IN (SELECT enabled_roles.role_name FROM enabled_roles))));


ALTER TABLE information_schema.role_column_grants OWNER TO postgres;

See Also

List of views


View: role_routine_grants

Properties

Name: role_routine_grants 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 grantor sql_identifier -1 
 grantee sql_identifier -1 
 specific_catalog sql_identifier -1 
 specific_schema sql_identifier -1 
 specific_name sql_identifier -1 
 routine_catalog sql_identifier -1 
 routine_schema sql_identifier -1 
 routine_name sql_identifier -1 
 privilege_type character_data -1 
 is_grantable character_data -1 
Total: 10 column(s)

SQL


CREATE VIEW role_routine_grants AS
    SELECT (u_grantor.rolname)::sql_identifier AS grantor, (g_grantee.rolname)::sql_identifier AS grantee, (current_database())::sql_identifier AS specific_catalog, (n.nspname)::sql_identifier AS specific_schema, ((((p.proname)::text || '_'::text) || (p.oid)::text))::sql_identifier AS specific_name, (current_database())::sql_identifier AS routine_catalog, (n.nspname)::sql_identifier AS routine_schema, (p.proname)::sql_identifier AS routine_name, ('EXECUTE'::character varying)::character_data AS privilege_type, (CASE WHEN aclcontains(p.proacl, makeaclitem(g_grantee.oid, u_grantor.oid, 'EXECUTE'::text, true)) THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_grantable FROM pg_proc p, pg_namespace n, pg_authid u_grantor, pg_authid g_grantee WHERE (((p.pronamespace = n.oid) AND aclcontains(p.proacl, makeaclitem(g_grantee.oid, u_grantor.oid, 'EXECUTE'::text, false))) AND ((u_grantor.rolname IN (SELECT enabled_roles.role_name FROM enabled_roles)) OR (g_grantee.rolname IN (SELECT enabled_roles.role_name FROM enabled_roles))));


ALTER TABLE information_schema.role_routine_grants OWNER TO postgres;

See Also

List of views


View: role_table_grants

Properties

Name: role_table_grants 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 grantor sql_identifier -1 
 grantee sql_identifier -1 
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 privilege_type character_data -1 
 is_grantable character_data -1 
 with_hierarchy character_data -1 
Total: 8 column(s)

SQL


CREATE VIEW role_table_grants AS
    SELECT (u_grantor.rolname)::sql_identifier AS grantor, (g_grantee.rolname)::sql_identifier AS grantee, (current_database())::sql_identifier AS table_catalog, (nc.nspname)::sql_identifier AS table_schema, (c.relname)::sql_identifier AS table_name, (pr."type")::character_data AS privilege_type, (CASE WHEN aclcontains(c.relacl, makeaclitem(g_grantee.oid, u_grantor.oid, pr."type", true)) THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_grantable, ('NO'::character varying)::character_data AS with_hierarchy FROM pg_class c, pg_namespace nc, pg_authid u_grantor, pg_authid g_grantee, (((((SELECT 'SELECT' UNION ALL SELECT 'DELETE') UNION ALL SELECT 'INSERT') UNION ALL SELECT 'UPDATE') UNION ALL SELECT 'REFERENCES') UNION ALL SELECT 'TRIGGER') pr("type") WHERE ((((c.relnamespace = nc.oid) AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND aclcontains(c.relacl, makeaclitem(g_grantee.oid, u_grantor.oid, pr."type", false))) AND ((u_grantor.rolname IN (SELECT enabled_roles.role_name FROM enabled_roles)) OR (g_grantee.rolname IN (SELECT enabled_roles.role_name FROM enabled_roles))));


ALTER TABLE information_schema.role_table_grants OWNER TO postgres;

See Also

List of views


View: role_usage_grants

Properties

Name: role_usage_grants 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 grantor sql_identifier -1 
 grantee sql_identifier -1 
 object_catalog sql_identifier -1 
 object_schema sql_identifier -1 
 object_name sql_identifier -1 
 object_type character_data -1 
 privilege_type character_data -1 
 is_grantable character_data -1 
Total: 8 column(s)

SQL


CREATE VIEW role_usage_grants AS
    SELECT (NULL::character varying)::sql_identifier AS grantor, (NULL::character varying)::sql_identifier AS grantee, (current_database())::sql_identifier AS object_catalog, (NULL::character varying)::sql_identifier AS object_schema, (NULL::character varying)::sql_identifier AS object_name, (NULL::character varying)::character_data AS object_type, ('USAGE'::character varying)::character_data AS privilege_type, (NULL::character varying)::character_data AS is_grantable WHERE false;


ALTER TABLE information_schema.role_usage_grants OWNER TO postgres;

See Also

List of views


View: routine_privileges

Properties

Name: routine_privileges 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 grantor sql_identifier -1 
 grantee sql_identifier -1 
 specific_catalog sql_identifier -1 
 specific_schema sql_identifier -1 
 specific_name sql_identifier -1 
 routine_catalog sql_identifier -1 
 routine_schema sql_identifier -1 
 routine_name sql_identifier -1 
 privilege_type character_data -1 
 is_grantable character_data -1 
Total: 10 column(s)

SQL


CREATE VIEW routine_privileges AS
    SELECT (u_grantor.rolname)::sql_identifier AS grantor, (grantee.rolname)::sql_identifier AS grantee, (current_database())::sql_identifier AS specific_catalog, (n.nspname)::sql_identifier AS specific_schema, ((((p.proname)::text || '_'::text) || (p.oid)::text))::sql_identifier AS specific_name, (current_database())::sql_identifier AS routine_catalog, (n.nspname)::sql_identifier AS routine_schema, (p.proname)::sql_identifier AS routine_name, ('EXECUTE'::character varying)::character_data AS privilege_type, (CASE WHEN aclcontains(p.proacl, makeaclitem(grantee.oid, u_grantor.oid, 'EXECUTE'::text, true)) THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_grantable FROM pg_proc p, pg_namespace n, pg_authid u_grantor, (SELECT pg_authid.oid, pg_authid.rolname FROM pg_authid UNION ALL SELECT (0)::oid AS oid, 'PUBLIC') grantee(oid, rolname) WHERE (((p.pronamespace = n.oid) AND aclcontains(p.proacl, makeaclitem(grantee.oid, u_grantor.oid, 'EXECUTE'::text, false))) AND ((pg_has_role(u_grantor.oid, 'USAGE'::text) OR pg_has_role(grantee.oid, 'USAGE'::text)) OR (grantee.rolname = 'PUBLIC'::name)));


ALTER TABLE information_schema.routine_privileges OWNER TO postgres;

See Also

List of views


View: routines

Properties

Name: routines 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 specific_catalog sql_identifier -1 
 specific_schema sql_identifier -1 
 specific_name sql_identifier -1 
 routine_catalog sql_identifier -1 
 routine_schema sql_identifier -1 
 routine_name sql_identifier -1 
 routine_type character_data -1 
 module_catalog sql_identifier -1 
 module_schema sql_identifier -1 
 module_name sql_identifier -1 
 udt_catalog sql_identifier -1 
 udt_schema sql_identifier -1 
 udt_name sql_identifier -1 
 data_type character_data -1 
 character_maximum_length cardinal_number -1 
 character_octet_length cardinal_number -1 
 character_set_catalog sql_identifier -1 
 character_set_schema sql_identifier -1 
 character_set_name sql_identifier -1 
 collation_catalog sql_identifier -1 
 collation_schema sql_identifier -1 
 collation_name sql_identifier -1 
 numeric_precision cardinal_number -1 
 numeric_precision_radix cardinal_number -1 
 numeric_scale cardinal_number -1 
 datetime_precision cardinal_number -1 
 interval_type character_data -1 
 interval_precision character_data -1 
 type_udt_catalog sql_identifier -1 
 type_udt_schema sql_identifier -1 
 type_udt_name sql_identifier -1 
 scope_catalog sql_identifier -1 
 scope_schema sql_identifier -1 
 scope_name sql_identifier -1 
 maximum_cardinality cardinal_number -1 
 dtd_identifier sql_identifier -1 
 routine_body character_data -1 
 routine_definition character_data -1 
 external_name character_data -1 
 external_language character_data -1 
 parameter_style character_data -1 
 is_deterministic character_data -1 
 sql_data_access character_data -1 
 is_null_call character_data -1 
 sql_path character_data -1 
 schema_level_routine character_data -1 
 max_dynamic_result_sets cardinal_number -1 
 is_user_defined_cast character_data -1 
 is_implicitly_invocable character_data -1 
 security_type character_data -1 
 to_sql_specific_catalog sql_identifier -1 
 to_sql_specific_schema sql_identifier -1 
 to_sql_specific_name sql_identifier -1 
 as_locator character_data -1 
 created time_stamp -1 
 last_altered time_stamp -1 
 new_savepoint_level character_data -1 
 is_udt_dependent character_data -1 
 result_cast_from_data_type character_data -1 
 result_cast_as_locator character_data -1 
 result_cast_char_max_length cardinal_number -1 
 result_cast_char_octet_length cardinal_number -1 
 result_cast_char_set_catalog sql_identifier -1 
 result_cast_char_set_schema sql_identifier -1 
 result_cast_character_set_name sql_identifier -1 
 result_cast_collation_catalog sql_identifier -1 
 result_cast_collation_schema sql_identifier -1 
 result_cast_collation_name sql_identifier -1 
 result_cast_numeric_precision cardinal_number -1 
 result_cast_numeric_precision_radix cardinal_number -1 
 result_cast_numeric_scale cardinal_number -1 
 result_cast_datetime_precision cardinal_number -1 
 result_cast_interval_type character_data -1 
 result_cast_interval_precision character_data -1 
 result_cast_type_udt_catalog sql_identifier -1 
 result_cast_type_udt_schema sql_identifier -1 
 result_cast_type_udt_name sql_identifier -1 
 result_cast_scope_catalog sql_identifier -1 
 result_cast_scope_schema sql_identifier -1 
 result_cast_scope_name sql_identifier -1 
 result_cast_maximum_cardinality cardinal_number -1 
 result_cast_dtd_identifier sql_identifier -1 
Total: 82 column(s)

SQL


CREATE VIEW routines AS
    SELECT (current_database())::sql_identifier AS specific_catalog, (n.nspname)::sql_identifier AS specific_schema, ((((p.proname)::text || '_'::text) || (p.oid)::text))::sql_identifier AS specific_name, (current_database())::sql_identifier AS routine_catalog, (n.nspname)::sql_identifier AS routine_schema, (p.proname)::sql_identifier AS routine_name, ('FUNCTION'::character varying)::character_data AS routine_type, (NULL::character varying)::sql_identifier AS module_catalog, (NULL::character varying)::sql_identifier AS module_schema, (NULL::character varying)::sql_identifier AS module_name, (NULL::character varying)::sql_identifier AS udt_catalog, (NULL::character varying)::sql_identifier AS udt_schema, (NULL::character varying)::sql_identifier AS udt_name, (CASE WHEN ((t.typelem <> (0)::oid) AND (t.typlen = -1)) THEN 'ARRAY'::text WHEN (nt.nspname = 'pg_catalog'::name) THEN format_type(t.oid, NULL::integer) ELSE 'USER-DEFINED'::text END)::character_data AS data_type, (NULL::integer)::cardinal_number AS character_maximum_length, (NULL::integer)::cardinal_number AS character_octet_length, (NULL::character varying)::sql_identifier AS character_set_catalog, (NULL::character varying)::sql_identifier AS character_set_schema, (NULL::character varying)::sql_identifier AS character_set_name, (NULL::character varying)::sql_identifier AS collation_catalog, (NULL::character varying)::sql_identifier AS collation_schema, (NULL::character varying)::sql_identifier AS collation_name, (NULL::integer)::cardinal_number AS numeric_precision, (NULL::integer)::cardinal_number AS numeric_precision_radix, (NULL::integer)::cardinal_number AS numeric_scale, (NULL::integer)::cardinal_number AS datetime_precision, (NULL::character varying)::character_data AS interval_type, (NULL::character varying)::character_data AS interval_precision, (current_database())::sql_identifier AS type_udt_catalog, (nt.nspname)::sql_identifier AS type_udt_schema, (t.typname)::sql_identifier AS type_udt_name, (NULL::character varying)::sql_identifier AS scope_catalog, (NULL::character varying)::sql_identifier AS scope_schema, (NULL::character varying)::sql_identifier AS scope_name, (NULL::integer)::cardinal_number AS maximum_cardinality, (0)::sql_identifier AS dtd_identifier, (CASE WHEN (l.lanname = 'sql'::name) THEN 'SQL'::text ELSE 'EXTERNAL'::text END)::character_data AS routine_body, (CASE WHEN pg_has_role(p.proowner, 'USAGE'::text) THEN p.prosrc ELSE NULL::text END)::character_data AS routine_definition, (CASE WHEN (l.lanname = 'c'::name) THEN p.prosrc ELSE NULL::text END)::character_data AS external_name, (upper((l.lanname)::text))::character_data AS external_language, ('GENERAL'::character varying)::character_data AS parameter_style, (CASE WHEN (p.provolatile = 'i'::"char") THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_deterministic, ('MODIFIES'::character varying)::character_data AS sql_data_access, (CASE WHEN p.proisstrict THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_null_call, (NULL::character varying)::character_data AS sql_path, ('YES'::character varying)::character_data AS schema_level_routine, (0)::cardinal_number AS max_dynamic_result_sets, (NULL::character varying)::character_data AS is_user_defined_cast, (NULL::character varying)::character_data AS is_implicitly_invocable, (CASE WHEN p.prosecdef THEN 'DEFINER'::text ELSE 'INVOKER'::text END)::character_data AS security_type, (NULL::character varying)::sql_identifier AS to_sql_specific_catalog, (NULL::character varying)::sql_identifier AS to_sql_specific_schema, (NULL::character varying)::sql_identifier AS to_sql_specific_name, ('NO'::character varying)::character_data AS as_locator, (NULL::timestamp with time zone)::time_stamp AS created, (NULL::timestamp with time zone)::time_stamp AS last_altered, (NULL::character varying)::character_data AS new_savepoint_level, ('YES'::character varying)::character_data AS is_udt_dependent, (NULL::character varying)::character_data AS result_cast_from_data_type, (NULL::character varying)::character_data AS result_cast_as_locator, (NULL::integer)::cardinal_number AS result_cast_char_max_length, (NULL::integer)::cardinal_number AS result_cast_char_octet_length, (NULL::character varying)::sql_identifier AS result_cast_char_set_catalog, (NULL::character varying)::sql_identifier AS result_cast_char_set_schema, (NULL::character varying)::sql_identifier AS result_cast_character_set_name, (NULL::character varying)::sql_identifier AS result_cast_collation_catalog, (NULL::character varying)::sql_identifier AS result_cast_collation_schema, (NULL::character varying)::sql_identifier AS result_cast_collation_name, (NULL::integer)::cardinal_number AS result_cast_numeric_precision, (NULL::integer)::cardinal_number AS result_cast_numeric_precision_radix, (NULL::integer)::cardinal_number AS result_cast_numeric_scale, (NULL::integer)::cardinal_number AS result_cast_datetime_precision, (NULL::character varying)::character_data AS result_cast_interval_type, (NULL::character varying)::character_data AS result_cast_interval_precision, (NULL::character varying)::sql_identifier AS result_cast_type_udt_catalog, (NULL::character varying)::sql_identifier AS result_cast_type_udt_schema, (NULL::character varying)::sql_identifier AS result_cast_type_udt_name, (NULL::character varying)::sql_identifier AS result_cast_scope_catalog, (NULL::character varying)::sql_identifier AS result_cast_scope_schema, (NULL::character varying)::sql_identifier AS result_cast_scope_name, (NULL::integer)::cardinal_number AS result_cast_maximum_cardinality, (NULL::character varying)::sql_identifier AS result_cast_dtd_identifier FROM pg_namespace n, pg_proc p, pg_language l, pg_type t, pg_namespace nt WHERE (((((n.oid = p.pronamespace) AND (p.prolang = l.oid)) AND (p.prorettype = t.oid)) AND (t.typnamespace = nt.oid)) AND (pg_has_role(p.proowner, 'USAGE'::text) OR has_function_privilege(p.oid, 'EXECUTE'::text)));


ALTER TABLE information_schema.routines OWNER TO postgres;

See Also

List of views


View: schemata

Properties

Name: schemata 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 catalog_name sql_identifier -1 
 schema_name sql_identifier -1 
 schema_owner sql_identifier -1 
 default_character_set_catalog sql_identifier -1 
 default_character_set_schema sql_identifier -1 
 default_character_set_name sql_identifier -1 
 sql_path character_data -1 
Total: 7 column(s)

SQL


CREATE VIEW schemata AS
    SELECT (current_database())::sql_identifier AS catalog_name, (n.nspname)::sql_identifier AS schema_name, (u.rolname)::sql_identifier AS schema_owner, (NULL::character varying)::sql_identifier AS default_character_set_catalog, (NULL::character varying)::sql_identifier AS default_character_set_schema, (NULL::character varying)::sql_identifier AS default_character_set_name, (NULL::character varying)::character_data AS sql_path FROM pg_namespace n, pg_authid u WHERE ((n.nspowner = u.oid) AND pg_has_role(n.nspowner, 'USAGE'::text));


ALTER TABLE information_schema.schemata OWNER TO postgres;

See Also

List of views


View: sequences

Properties

Name: sequences 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 sequence_catalog sql_identifier -1 
 sequence_schema sql_identifier -1 
 sequence_name sql_identifier -1 
 data_type character_data -1 
 numeric_precision cardinal_number -1 
 numeric_precision_radix cardinal_number -1 
 numeric_scale cardinal_number -1 
 maximum_value cardinal_number -1 
 minimum_value cardinal_number -1 
 increment cardinal_number -1 
 cycle_option character_data -1 
Total: 11 column(s)

SQL


CREATE VIEW sequences AS
    SELECT (current_database())::sql_identifier AS sequence_catalog, (nc.nspname)::sql_identifier AS sequence_schema, (c.relname)::sql_identifier AS sequence_name, ('bigint'::character varying)::character_data AS data_type, (64)::cardinal_number AS numeric_precision, (2)::cardinal_number AS numeric_precision_radix, (0)::cardinal_number AS numeric_scale, (NULL::integer)::cardinal_number AS maximum_value, (NULL::integer)::cardinal_number AS minimum_value, (NULL::integer)::cardinal_number AS "increment", (NULL::character varying)::character_data AS cycle_option FROM pg_namespace nc, pg_class c WHERE ((((c.relnamespace = nc.oid) AND (c.relkind = 'S'::"char")) AND (NOT pg_is_other_temp_schema(nc.oid))) AND ((pg_has_role(c.relowner, 'USAGE'::text) OR has_table_privilege(c.oid, 'SELECT'::text)) OR has_table_privilege(c.oid, 'UPDATE'::text)));


ALTER TABLE information_schema.sequences OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

See Also

List of views


View: table_constraints

Properties

Name: table_constraints 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 constraint_catalog varchar -1 
 constraint_schema varchar -1 
 constraint_name varchar -1 
 table_catalog varchar -1 
 table_schema varchar -1 
 table_name varchar -1 
 constraint_type varchar -1 
 is_deferrable varchar -1 
 initially_deferred varchar -1 
Total: 9 column(s)

SQL


CREATE VIEW table_constraints AS
    SELECT (current_database())::sql_identifier AS constraint_catalog, (nc.nspname)::sql_identifier AS constraint_schema, (c.conname)::sql_identifier AS constraint_name, (current_database())::sql_identifier AS table_catalog, (nr.nspname)::sql_identifier AS table_schema, (r.relname)::sql_identifier AS table_name, (CASE c.contype WHEN 'c'::"char" THEN 'CHECK'::text WHEN 'f'::"char" THEN 'FOREIGN KEY'::text WHEN 'p'::"char" THEN 'PRIMARY KEY'::text WHEN 'u'::"char" THEN 'UNIQUE'::text ELSE NULL::text END)::character_data AS constraint_type, (CASE WHEN c.condeferrable THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_deferrable, (CASE WHEN c.condeferred THEN 'YES'::text ELSE 'NO'::text END)::character_data AS initially_deferred FROM pg_namespace nc, pg_namespace nr, pg_constraint c, pg_class r WHERE ((((((nc.oid = c.connamespace) AND (nr.oid = r.relnamespace)) AND (c.conrelid = r.oid)) AND (r.relkind = 'r'::"char")) AND (NOT pg_is_other_temp_schema(nr.oid))) AND (((((pg_has_role(r.relowner, 'USAGE'::text) OR has_table_privilege(r.oid, 'INSERT'::text)) OR has_table_privilege(r.oid, 'UPDATE'::text)) OR has_table_privilege(r.oid, 'DELETE'::text)) OR has_table_privilege(r.oid, 'REFERENCES'::text)) OR has_table_privilege(r.oid, 'TRIGGER'::text))) UNION SELECT (current_database())::sql_identifier AS constraint_catalog, (nr.nspname)::sql_identifier AS constraint_schema, (((((((nr.oid)::text || '_'::text) || (r.oid)::text) || '_'::text) || (a.attnum)::text) || '_not_null'::text))::sql_identifier AS constraint_name, (current_database())::sql_identifier AS table_catalog, (nr.nspname)::sql_identifier AS table_schema, (r.relname)::sql_identifier AS table_name, ('CHECK'::character varying)::character_data AS constraint_type, ('NO'::character varying)::character_data AS is_deferrable, ('NO'::character varying)::character_data AS initially_deferred FROM pg_namespace nr, pg_class r, pg_attribute a WHERE ((((((((nr.oid = r.relnamespace) AND (r.oid = a.attrelid)) AND a.attnotnull) AND (a.attnum > 0)) AND (NOT a.attisdropped)) AND (r.relkind = 'r'::"char")) AND (NOT pg_is_other_temp_schema(nr.oid))) AND ((((((pg_has_role(r.relowner, 'USAGE'::text) OR has_table_privilege(r.oid, 'SELECT'::text)) OR has_table_privilege(r.oid, 'INSERT'::text)) OR has_table_privilege(r.oid, 'UPDATE'::text)) OR has_table_privilege(r.oid, 'DELETE'::text)) OR has_table_privilege(r.oid, 'REFERENCES'::text)) OR has_table_privilege(r.oid, 'TRIGGER'::text)));


ALTER TABLE information_schema.table_constraints OWNER TO postgres;

See Also

List of views


View: table_privileges

Properties

Name: table_privileges 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 grantor sql_identifier -1 
 grantee sql_identifier -1 
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 privilege_type character_data -1 
 is_grantable character_data -1 
 with_hierarchy character_data -1 
Total: 8 column(s)

SQL


CREATE VIEW table_privileges AS
    SELECT (u_grantor.rolname)::sql_identifier AS grantor, (grantee.rolname)::sql_identifier AS grantee, (current_database())::sql_identifier AS table_catalog, (nc.nspname)::sql_identifier AS table_schema, (c.relname)::sql_identifier AS table_name, (pr."type")::character_data AS privilege_type, (CASE WHEN aclcontains(c.relacl, makeaclitem(grantee.oid, u_grantor.oid, pr."type", true)) THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_grantable, ('NO'::character varying)::character_data AS with_hierarchy FROM pg_class c, pg_namespace nc, pg_authid u_grantor, (SELECT pg_authid.oid, pg_authid.rolname FROM pg_authid UNION ALL SELECT (0)::oid AS oid, 'PUBLIC') grantee(oid, rolname), (((((SELECT 'SELECT' UNION ALL SELECT 'DELETE') UNION ALL SELECT 'INSERT') UNION ALL SELECT 'UPDATE') UNION ALL SELECT 'REFERENCES') UNION ALL SELECT 'TRIGGER') pr("type") WHERE ((((c.relnamespace = nc.oid) AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND aclcontains(c.relacl, makeaclitem(grantee.oid, u_grantor.oid, pr."type", false))) AND ((pg_has_role(u_grantor.oid, 'USAGE'::text) OR pg_has_role(grantee.oid, 'USAGE'::text)) OR (grantee.rolname = 'PUBLIC'::name)));


ALTER TABLE information_schema.table_privileges OWNER TO postgres;

See Also

List of views


View: tables

Properties

Name: tables 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 table_type character_data -1 
 self_referencing_column_name sql_identifier -1 
 reference_generation character_data -1 
 user_defined_type_catalog sql_identifier -1 
 user_defined_type_schema sql_identifier -1 
 user_defined_type_name sql_identifier -1 
 is_insertable_into character_data -1 
 is_typed character_data -1 
 commit_action character_data -1 
Total: 12 column(s)

SQL


CREATE VIEW tables AS
    SELECT (current_database())::sql_identifier AS table_catalog, (nc.nspname)::sql_identifier AS table_schema, (c.relname)::sql_identifier AS table_name, (CASE WHEN (nc.oid = pg_my_temp_schema()) THEN 'LOCAL TEMPORARY'::text WHEN (c.relkind = 'r'::"char") THEN 'BASE TABLE'::text WHEN (c.relkind = 'v'::"char") THEN 'VIEW'::text ELSE NULL::text END)::character_data AS table_type, (NULL::character varying)::sql_identifier AS self_referencing_column_name, (NULL::character varying)::character_data AS reference_generation, (NULL::character varying)::sql_identifier AS user_defined_type_catalog, (NULL::character varying)::sql_identifier AS user_defined_type_schema, (NULL::character varying)::sql_identifier AS user_defined_type_name, (CASE WHEN (c.relkind = 'r'::"char") THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_insertable_into, ('NO'::character varying)::character_data AS is_typed, (CASE WHEN (nc.oid = pg_my_temp_schema()) THEN 'PRESERVE'::text ELSE NULL::text END)::character_data AS commit_action FROM pg_namespace nc, pg_class c WHERE ((((c.relnamespace = nc.oid) AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND (NOT pg_is_other_temp_schema(nc.oid))) AND ((((((pg_has_role(c.relowner, 'USAGE'::text) OR has_table_privilege(c.oid, 'SELECT'::text)) OR has_table_privilege(c.oid, 'INSERT'::text)) OR has_table_privilege(c.oid, 'UPDATE'::text)) OR has_table_privilege(c.oid, 'DELETE'::text)) OR has_table_privilege(c.oid, 'REFERENCES'::text)) OR has_table_privilege(c.oid, 'TRIGGER'::text)));


ALTER TABLE information_schema.tables OWNER TO postgres;

See Also

List of views


View: triggered_update_columns

Properties

Name: triggered_update_columns 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 trigger_catalog sql_identifier -1 
 trigger_schema sql_identifier -1 
 trigger_name sql_identifier -1 
 event_object_catalog sql_identifier -1 
 event_object_schema sql_identifier -1 
 event_object_table sql_identifier -1 
 event_object_column sql_identifier -1 
Total: 7 column(s)

SQL


CREATE VIEW triggered_update_columns AS
    SELECT (current_database())::sql_identifier AS trigger_catalog, (NULL::character varying)::sql_identifier AS trigger_schema, (NULL::character varying)::sql_identifier AS trigger_name, (current_database())::sql_identifier AS event_object_catalog, (NULL::character varying)::sql_identifier AS event_object_schema, (NULL::character varying)::sql_identifier AS event_object_table, (NULL::character varying)::sql_identifier AS event_object_column WHERE false;


ALTER TABLE information_schema.triggered_update_columns OWNER TO postgres;

See Also

List of views


View: triggers

Properties

Name: triggers 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 trigger_catalog sql_identifier -1 
 trigger_schema sql_identifier -1 
 trigger_name sql_identifier -1 
 event_manipulation character_data -1 
 event_object_catalog sql_identifier -1 
 event_object_schema sql_identifier -1 
 event_object_table sql_identifier -1 
 action_order cardinal_number -1 
 action_condition character_data -1 
 action_statement character_data -1 
 action_orientation character_data -1 
 condition_timing character_data -1 
 condition_reference_old_table sql_identifier -1 
 condition_reference_new_table sql_identifier -1 
 condition_reference_old_row sql_identifier -1 
 condition_reference_new_row sql_identifier -1 
 created time_stamp -1 
Total: 17 column(s)

SQL


CREATE VIEW triggers AS
    SELECT (current_database())::sql_identifier AS trigger_catalog, (n.nspname)::sql_identifier AS trigger_schema, (t.tgname)::sql_identifier AS trigger_name, (em.text)::character_data AS event_manipulation, (current_database())::sql_identifier AS event_object_catalog, (n.nspname)::sql_identifier AS event_object_schema, (c.relname)::sql_identifier AS event_object_table, (NULL::integer)::cardinal_number AS action_order, (NULL::character varying)::character_data AS action_condition, ("substring"(pg_get_triggerdef(t.oid), ("position"("substring"(pg_get_triggerdef(t.oid), 48), 'EXECUTE PROCEDURE'::text) + 47)))::character_data AS action_statement, (CASE WHEN (((t.tgtype)::integer & 1) = 1) THEN 'ROW'::text ELSE 'STATEMENT'::text END)::character_data AS action_orientation, (CASE WHEN (((t.tgtype)::integer & 2) = 2) THEN 'BEFORE'::text ELSE 'AFTER'::text END)::character_data AS condition_timing, (NULL::character varying)::sql_identifier AS condition_reference_old_table, (NULL::character varying)::sql_identifier AS condition_reference_new_table, (NULL::character varying)::sql_identifier AS condition_reference_old_row, (NULL::character varying)::sql_identifier AS condition_reference_new_row, (NULL::timestamp with time zone)::time_stamp AS created FROM pg_namespace n, pg_class c, pg_trigger t, ((SELECT 4, 'INSERT' UNION ALL SELECT 8, 'DELETE') UNION ALL SELECT 16, 'UPDATE') em(num, text) WHERE ((((((n.oid = c.relnamespace) AND (c.oid = t.tgrelid)) AND (((t.tgtype)::integer & em.num) <> 0)) AND (NOT t.tgisconstraint)) AND (NOT pg_is_other_temp_schema(n.oid))) AND (((((pg_has_role(c.relowner, 'USAGE'::text) OR has_table_privilege(c.oid, 'INSERT'::text)) OR has_table_privilege(c.oid, 'UPDATE'::text)) OR has_table_privilege(c.oid, 'DELETE'::text)) OR has_table_privilege(c.oid, 'REFERENCES'::text)) OR has_table_privilege(c.oid, 'TRIGGER'::text)));


ALTER TABLE information_schema.triggers OWNER TO postgres;

See Also

List of views


View: usage_privileges

Properties

Name: usage_privileges 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 grantor sql_identifier -1 
 grantee sql_identifier -1 
 object_catalog sql_identifier -1 
 object_schema sql_identifier -1 
 object_name sql_identifier -1 
 object_type character_data -1 
 privilege_type character_data -1 
 is_grantable character_data -1 
Total: 8 column(s)

SQL


CREATE VIEW usage_privileges AS
    SELECT (u.rolname)::sql_identifier AS grantor, ('PUBLIC'::character varying)::sql_identifier AS grantee, (current_database())::sql_identifier AS object_catalog, (n.nspname)::sql_identifier AS object_schema, (t.typname)::sql_identifier AS object_name, ('DOMAIN'::character varying)::character_data AS object_type, ('USAGE'::character varying)::character_data AS privilege_type, ('NO'::character varying)::character_data AS is_grantable FROM pg_authid u, pg_namespace n, pg_type t WHERE (((u.oid = t.typowner) AND (t.typnamespace = n.oid)) AND (t.typtype = 'd'::"char"));


ALTER TABLE information_schema.usage_privileges OWNER TO postgres;

See Also

List of views


View: view_column_usage

Properties

Name: view_column_usage 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 view_catalog sql_identifier -1 
 view_schema sql_identifier -1 
 view_name sql_identifier -1 
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 column_name sql_identifier -1 
Total: 7 column(s)

SQL


CREATE VIEW view_column_usage AS
    SELECT DISTINCT (current_database())::sql_identifier AS view_catalog, (nv.nspname)::sql_identifier AS view_schema, (v.relname)::sql_identifier AS view_name, (current_database())::sql_identifier AS table_catalog, (nt.nspname)::sql_identifier AS table_schema, (t.relname)::sql_identifier AS table_name, (a.attname)::sql_identifier AS column_name FROM pg_namespace nv, pg_class v, pg_depend dv, pg_depend dt, pg_class t, pg_namespace nt, pg_attribute a WHERE ((((((((((((((((nv.oid = v.relnamespace) AND (v.relkind = 'v'::"char")) AND (v.oid = dv.refobjid)) AND (dv.refclassid = ('pg_class'::regclass)::oid)) AND (dv.classid = ('pg_rewrite'::regclass)::oid)) AND (dv.deptype = 'i'::"char")) AND (dv.objid = dt.objid)) AND (dv.refobjid <> dt.refobjid)) AND (dt.classid = ('pg_rewrite'::regclass)::oid)) AND (dt.refclassid = ('pg_class'::regclass)::oid)) AND (dt.refobjid = t.oid)) AND (t.relnamespace = nt.oid)) AND (t.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND (t.oid = a.attrelid)) AND (dt.refobjsubid = a.attnum)) AND pg_has_role(t.relowner, 'USAGE'::text)) ORDER BY (current_database())::sql_identifier, (nv.nspname)::sql_identifier, (v.relname)::sql_identifier, (current_database())::sql_identifier, (nt.nspname)::sql_identifier, (t.relname)::sql_identifier, (a.attname)::sql_identifier;


ALTER TABLE information_schema.view_column_usage OWNER TO postgres;

See Also

List of views


View: view_routine_usage

Properties

Name: view_routine_usage 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 specific_catalog sql_identifier -1 
 specific_schema sql_identifier -1 
 specific_name sql_identifier -1 
Total: 6 column(s)

SQL


CREATE VIEW view_routine_usage AS
    SELECT DISTINCT (current_database())::sql_identifier AS table_catalog, (nv.nspname)::sql_identifier AS table_schema, (v.relname)::sql_identifier AS table_name, (current_database())::sql_identifier AS specific_catalog, (np.nspname)::sql_identifier AS specific_schema, ((((p.proname)::text || '_'::text) || (p.oid)::text))::sql_identifier AS specific_name FROM pg_namespace nv, pg_class v, pg_depend dv, pg_depend dp, pg_proc p, pg_namespace np WHERE ((((((((((((nv.oid = v.relnamespace) AND (v.relkind = 'v'::"char")) AND (v.oid = dv.refobjid)) AND (dv.refclassid = ('pg_class'::regclass)::oid)) AND (dv.classid = ('pg_rewrite'::regclass)::oid)) AND (dv.deptype = 'i'::"char")) AND (dv.objid = dp.objid)) AND (dp.classid = ('pg_rewrite'::regclass)::oid)) AND (dp.refclassid = ('pg_proc'::regclass)::oid)) AND (dp.refobjid = p.oid)) AND (p.pronamespace = np.oid)) AND pg_has_role(p.proowner, 'USAGE'::text)) ORDER BY (current_database())::sql_identifier, (nv.nspname)::sql_identifier, (v.relname)::sql_identifier, (current_database())::sql_identifier, (np.nspname)::sql_identifier, ((((p.proname)::text || '_'::text) || (p.oid)::text))::sql_identifier;


ALTER TABLE information_schema.view_routine_usage OWNER TO postgres;

See Also

List of views


View: view_table_usage

Properties

Name: view_table_usage 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 view_catalog sql_identifier -1 
 view_schema sql_identifier -1 
 view_name sql_identifier -1 
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
Total: 6 column(s)

SQL


CREATE VIEW view_table_usage AS
    SELECT DISTINCT (current_database())::sql_identifier AS view_catalog, (nv.nspname)::sql_identifier AS view_schema, (v.relname)::sql_identifier AS view_name, (current_database())::sql_identifier AS table_catalog, (nt.nspname)::sql_identifier AS table_schema, (t.relname)::sql_identifier AS table_name FROM pg_namespace nv, pg_class v, pg_depend dv, pg_depend dt, pg_class t, pg_namespace nt WHERE ((((((((((((((nv.oid = v.relnamespace) AND (v.relkind = 'v'::"char")) AND (v.oid = dv.refobjid)) AND (dv.refclassid = ('pg_class'::regclass)::oid)) AND (dv.classid = ('pg_rewrite'::regclass)::oid)) AND (dv.deptype = 'i'::"char")) AND (dv.objid = dt.objid)) AND (dv.refobjid <> dt.refobjid)) AND (dt.classid = ('pg_rewrite'::regclass)::oid)) AND (dt.refclassid = ('pg_class'::regclass)::oid)) AND (dt.refobjid = t.oid)) AND (t.relnamespace = nt.oid)) AND (t.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND pg_has_role(t.relowner, 'USAGE'::text)) ORDER BY (current_database())::sql_identifier, (nv.nspname)::sql_identifier, (v.relname)::sql_identifier, (current_database())::sql_identifier, (nt.nspname)::sql_identifier, (t.relname)::sql_identifier;


ALTER TABLE information_schema.view_table_usage OWNER TO postgres;

See Also

List of views


View: views

Properties

Name: views 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

NameTypeLength
 table_catalog sql_identifier -1 
 table_schema sql_identifier -1 
 table_name sql_identifier -1 
 view_definition character_data -1 
 check_option character_data -1 
 is_updatable character_data -1 
 is_insertable_into character_data -1 
Total: 7 column(s)

SQL


CREATE VIEW views AS
    SELECT (current_database())::sql_identifier AS table_catalog, (nc.nspname)::sql_identifier AS table_schema, (c.relname)::sql_identifier AS table_name, (CASE WHEN pg_has_role(c.relowner, 'USAGE'::text) THEN pg_get_viewdef(c.oid) ELSE NULL::text END)::character_data AS view_definition, ('NONE'::character varying)::character_data AS check_option, (CASE WHEN ((EXISTS (SELECT 1 FROM pg_rewrite WHERE (((pg_rewrite.ev_class = c.oid) AND ((pg_rewrite.ev_type)::text = (2)::text)) AND pg_rewrite.is_instead))) AND (EXISTS (SELECT 1 FROM pg_rewrite WHERE (((pg_rewrite.ev_class = c.oid) AND ((pg_rewrite.ev_type)::text = (4)::text)) AND pg_rewrite.is_instead)))) THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_updatable, (CASE WHEN (EXISTS (SELECT 1 FROM pg_rewrite WHERE (((pg_rewrite.ev_class = c.oid) AND ((pg_rewrite.ev_type)::text = (3)::text)) AND pg_rewrite.is_instead))) THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_insertable_into FROM pg_namespace nc, pg_class c WHERE ((((c.relnamespace = nc.oid) AND (c.relkind = 'v'::"char")) AND (NOT pg_is_other_temp_schema(nc.oid))) AND ((((((pg_has_role(c.relowner, 'USAGE'::text) OR has_table_privilege(c.oid, 'SELECT'::text)) OR has_table_privilege(c.oid, 'INSERT'::text)) OR has_table_privilege(c.oid, 'UPDATE'::text)) OR has_table_privilege(c.oid, 'DELETE'::text)) OR has_table_privilege(c.oid, 'REFERENCES'::text)) OR has_table_privilege(c.oid, 'TRIGGER'::text)));


ALTER TABLE information_schema.views OWNER TO postgres;

See Also

List of views




Server: Server

Properties

MachineName: Server 
version: PostgreSQL 8.2.5 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special) 

Databases

NameOwnerEncodingDefault schemaComment
 postgres postgres SQL_ASCII  
Total: 1 database(s)

Tablespaces

NameOwnerLocation
 pg_default postgres  
 pg_global postgres  
Total: 2 tablespace(s)

Logins

NameSuperuser
 postgres  
Total: 1 login(s)

Tablespaces


Tablespace: pg_default

Properties

Name: pg_default 
Owner: postgres 
Location:  

See Also

List of tablespaces


Tablespace: pg_global

Properties

Name: pg_global 
Owner: postgres 
Location:  

See Also

List of tablespaces


Logins


Login: postgres

Properties

Name: postgres 
Superuser:  
Inherits:  
Createroles:  
Createdb:  
Update catalogs:  
Canlogin:  
Connections limit: -1 
Valid until:  
Config:  

See Also

List of logins



About

Documentation details

Customer:  
Project:  
Created: 12/24/2007