
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
postgres |
postgres |
SQL_ASCII |
|
|
unlimited |
pg_default |
|
|
1 |
Schemas
Total: 3 schema(s)List of databases Schemas
Schema: pg_toast
Properties
pg_toast |
postgres |
|
Reserved schema for TOAST tables |
Domains
Total: 2 domain(s) Tables
Total: 16 table(s) Types
Total: 16 type(s)List of schemas Domains
Domain: domain1
Properties
domain1 |
16449 |
postgres |
bigint |
1 |
|
|
test domain |
SQL
List of domains
Domain: rrr
Properties
rrr |
16450 |
postgres |
integer |
34 |
CHECK ((VALUE > 33)) |
|
|
SQL
List of domains Tables
Table: pg_toast_10737
Properties
pg_toast_10737 |
postgres |
|
|
|
|
0 |
|
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_10737_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_10742
Properties
pg_toast_10742 |
postgres |
|
|
|
|
0 |
|
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_10742_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_10747
Properties
pg_toast_10747 |
postgres |
|
|
|
|
0 |
|
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_10747_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_10752
Properties
pg_toast_10752 |
postgres |
|
|
|
|
0 |
|
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_10752_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_10757
Properties
pg_toast_10757 |
postgres |
|
|
|
|
0 |
|
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_10757_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_10762
Properties
pg_toast_10762 |
postgres |
|
|
|
|
0 |
|
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_10762_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_10767
Properties
pg_toast_10767 |
postgres |
|
|
|
|
0 |
|
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_10767_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_1255
Properties
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_1255_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_1260
Properties
pg_toast_1260 |
postgres |
pg_global |
|
|
|
0 |
|
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_1260_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_1262
Properties
pg_toast_1262 |
postgres |
pg_global |
|
|
|
0 |
|
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_1262_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_2396
Properties
pg_toast_2396 |
postgres |
pg_global |
|
|
|
0 |
|
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_2396_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_2604
Properties
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_2604_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_2606
Properties
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_2606_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_2609
Properties
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_2609_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_2618
Properties
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_2618_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes
Table: pg_toast_2619
Properties
Columns
| 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
Total: 1 index(es) SQL
List of tables Indexes
Index: pg_toast_2619_index
Properties
Columns
| chunk_id |
| chunk_seq |
Total: 2 index column(s) SQL
List of indexes Types
Type: pg_toast_10737
Properties
pg_toast_10737 |
10740 |
postgres |
pg_toast.pg_toast_10737 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_10742
Properties
pg_toast_10742 |
10745 |
postgres |
pg_toast.pg_toast_10742 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_10747
Properties
pg_toast_10747 |
10750 |
postgres |
pg_toast.pg_toast_10747 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_10752
Properties
pg_toast_10752 |
10755 |
postgres |
pg_toast.pg_toast_10752 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_10757
Properties
pg_toast_10757 |
10760 |
postgres |
pg_toast.pg_toast_10757 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_10762
Properties
pg_toast_10762 |
10765 |
postgres |
pg_toast.pg_toast_10762 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_10767
Properties
pg_toast_10767 |
10770 |
postgres |
pg_toast.pg_toast_10767 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_1255
Properties
pg_toast_1255 |
10288 |
postgres |
pg_toast.pg_toast_1255 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_1260
Properties
pg_toast_1260 |
10291 |
postgres |
pg_toast.pg_toast_1260 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_1262
Properties
pg_toast_1262 |
10292 |
postgres |
pg_toast.pg_toast_1262 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_2396
Properties
pg_toast_2396 |
10293 |
postgres |
pg_toast.pg_toast_2396 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_2604
Properties
pg_toast_2604 |
10285 |
postgres |
pg_toast.pg_toast_2604 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_2606
Properties
pg_toast_2606 |
10286 |
postgres |
pg_toast.pg_toast_2606 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_2609
Properties
pg_toast_2609 |
10287 |
postgres |
pg_toast.pg_toast_2609 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_2618
Properties
pg_toast_2618 |
10289 |
postgres |
pg_toast.pg_toast_2618 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_toast_2619
Properties
pg_toast_2619 |
10290 |
postgres |
pg_toast.pg_toast_2619 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Schema: public
Properties
public |
postgres |
|
Standard public schema |
Aggregates
Total: 1 aggregate(s) Conversions
Total: 1 conversion(s) Domains
Total: 2 domain(s) Functions
Total: 1 function(s) Trigger functions
Total: 1 trigger function(s) Procedures
Total: 2 procedure(s) Operators
Total: 1 operator(s) Operator classses
Total: 1 opclass(s) Sequences
Total: 3 sequence(s) Tables
Total: 2 table(s) Types
Total: 7 type(s) Views
| view1 | postgres | example view |
Total: 1 view(s)List of schemas Aggregates
Aggregate: avg1(interval)
Properties
avg1(interval) |
interval |
postgres |
interval[] |
interval_avg |
interval |
interval_avg |
|
{0 second,0 second} |
|
|
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;
List of aggregates Conversions
Conversion: ascii_to_mic
Properties
ascii_to_mic |
postgres |
public |
SQL_ASCII |
MULE_INTERNAL |
ascii_to_mic |
|
|
|
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;
List of conversions Domains
Domain: domain1
Properties
domain1 |
16449 |
postgres |
bigint |
1 |
|
|
test domain |
SQL
CREATE DOMAIN domain1 AS bigint NOT NULL DEFAULT 1;
ALTER DOMAIN public.domain1 OWNER TO postgres;
List of domains
Domain: rrr
Properties
rrr |
16450 |
postgres |
integer |
34 |
CHECK ((VALUE > 33)) |
|
|
SQL
CREATE DOMAIN rrr AS integer NOT NULL DEFAULT 34
CONSTRAINT rrr_check CHECK ((VALUE > 33));
ALTER DOMAIN public.rrr OWNER TO postgres;
List of domains Functions
Function: abbrev(inet)
Properties
abbrev |
abbrev(inet) |
postgres |
1 |
text |
internal |
|
inet_abbrev |
|
|
|
|
SQL
CREATE FUNCTION abbrev(inet) RETURNS text
AS $$inet_abbrev$$
LANGUAGE internal IMMUTABLE STRICT;
ALTER FUNCTION public.abbrev(inet) OWNER TO postgres;
List of functions Trigger Functions
Trigger function: RI_FKey_cascade_del
Properties
RI_FKey_cascade_del |
postgres |
0 |
trigger |
internal |
|
RI_FKey_cascade_del |
|
|
|
|
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;
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
pg_stat_file |
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 |
1 |
record |
internal |
|
pg_stat_file |
|
|
|
|
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;
List of procedures
Procedure: pg_timezone_abbrevs(OUT abbrev text, OUT utc_offset interval, OUT is_dst boolean)
Properties
pg_timezone_abbrevs |
pg_timezone_abbrevs(OUT abbrev text, OUT utc_offset interval, OUT is_dst boolean) |
postgres |
0 |
record |
internal |
|
pg_timezone_abbrevs |
|
|
|
|
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;
List of procedures Operators
Operator: ! (int8)
Properties
! |
16480 |
postgres |
POSTFIX |
int8 |
|
numeric |
|
|
|
|
|
|
|
|
|
|
SQL
CREATE OPERATOR ! (
PROCEDURE = numeric_fac,
LEFTARG = bigint
);
ALTER OPERATOR public.! (bigint, NONE) OWNER TO postgres;
List of operators Operator Classes
Operator class: _char_ops1
Properties
_char_ops1 |
16476 |
postgres |
|
_char |
gin |
|
|
1 &&(anyarray,anyarray) |
2 @>(anyarray,anyarray) |
3 <@(anyarray,anyarray) |
4 =(anyarray,anyarray) |
btcharcmp("char", "char") |
ginarrayextract(anyarray, internal) |
ginarrayextract(anyarray, internal) |
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;
List of operator classes Sequences
Sequence: sq_1
Properties
sq_1 |
16445 |
postgres |
1 |
1 |
9223372036854775807 |
1 |
1 |
|
|
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;
List of sequences
Sequence: sq_example
Properties
sq_example |
16443 |
postgres |
1 |
1 |
9223372036854775807 |
1 |
1 |
|
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;
List of sequences
Sequence: ww
Properties
ww |
16447 |
postgres |
1 |
1 |
12 |
1 |
1 |
|
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;
List of sequences Tables
Table: pg_amop
Properties
Columns
| 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
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;
List of tables Indexes
Index: pg_amop_opc_strat_index
Properties
Columns
| amopclaid |
| amopsubtype |
| amopstrategy |
Total: 3 index column(s) SQL
List of indexes
Index: pg_amop_opr_opc_index
Properties
Columns
| amopclaid |
| amopopr |
Total: 2 index column(s) SQL
List of indexes
Table: pg_amop1
Properties
Columns
| 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
Total: 1 constraint(s) Indexes
Total: 1 index(es) Rules
Total: 1 rule(s) Triggers
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;
List of tables Indexes
Index: index1
Properties
Columns
| amopclaid |
Total: 1 index column(s) SQL
CREATE UNIQUE INDEX index1 ON pg_amop1 USING btree (amopclaid);
ALTER TABLE pg_amop1 CLUSTER ON index1;
List of indexes Rules
Rule: ddd
Properties
ddd |
pg_amop1 |
DELETE |
|
SQL
CREATE RULE ddd AS ON DELETE TO pg_amop1 WHERE (old.amopclaid > (1)::oid) DO NOTHING;
Table overview Triggers
Trigger: tr_amo1
Properties
tr_amo1 |
ROW |
BEFORE |
|
|
|
flatfile_update_trigger |
|
|
|
trigger |
SQL
CREATE TRIGGER tr_amo1
BEFORE UPDATE ON pg_amop1
FOR EACH ROW
EXECUTE PROCEDURE flatfile_update_trigger();
List of triggers Constraints
Constraint: ddd
Properties
ddd |
unique |
|
|
|
|
|
|
|
dddd |
SQL
ALTER TABLE ONLY pg_amop1
ADD CONSTRAINT ddd UNIQUE (amopclaid);
List of constraints Types
Type: PIPPO
Properties
PIPPO |
16469 |
postgres |
"PIPPO" |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
CREATE TYPE "PIPPO" AS (
one money,
two numeric(10,10)
);
ALTER TYPE public."PIPPO" OWNER TO postgres;
List of types
Type: pg_amop
Properties
pg_amop |
16453 |
postgres |
public.pg_amop |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: pg_amop1
Properties
pg_amop1 |
16455 |
postgres |
pg_amop1 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: sq_1
Properties
sq_1 |
16446 |
postgres |
sq_1 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: sq_example
Properties
sq_example |
16444 |
postgres |
sq_example |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: view1
Properties
view1 |
16472 |
postgres |
view1 |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: ww
Properties
ww |
16448 |
postgres |
ww |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types Views
View: view1
Properties
view1 |
postgres |
|
|
example view |
Columns
| ?column? | int4 | -1 |
Total: 1 column(s) Rules
Total: 1 rule(s) SQL
CREATE VIEW view1 AS
SELECT 1 FROM pg_index;
ALTER TABLE public.view1 OWNER TO postgres;
List of views Rules
Rule: view1_ondelete
Properties
view1_ondelete |
view1 |
DELETE |
|
|
SQL
CREATE RULE view1_ondelete AS ON DELETE TO view1 WHERE (1 > 1) DO NOTHING;
View overview
Schema: information_schema
Properties
information_schema |
postgres |
|
|
Domains
Total: 2 domain(s) Functions
Total: 12 function(s) Procedures
Total: 1 procedure(s) Tables
Total: 7 table(s) Types
Total: 46 type(s) Views
Total: 39 view(s)List of schemas Domains
Domain: domain1
Properties
domain1 |
16449 |
postgres |
bigint |
1 |
|
|
test domain |
SQL
List of domains
Domain: rrr
Properties
rrr |
16450 |
postgres |
integer |
34 |
CHECK ((VALUE > 33)) |
|
|
SQL
List of domains Functions
Function: _pg_char_max_length(oid, integer)
Properties
_pg_char_max_length |
_pg_char_max_length(oid, integer) |
postgres |
2 |
int4 |
sql |
|
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 |
|
|
|
|
SQL
CREATE FUNCTION _pg_char_max_length(typid oid, typmod integer) RETURNS integer
AS $_$SELECT
CASE WHEN $2 = -1
THEN null
WHEN $1 IN (1042, 1043)
THEN $2 - 4
WHEN $1 IN (1560, 1562)
THEN $2
ELSE null
END$_$
LANGUAGE sql IMMUTABLE STRICT;
ALTER FUNCTION information_schema._pg_char_max_length(typid oid, typmod integer) OWNER TO postgres;
List of functions
Function: _pg_char_octet_length(oid, integer)
Properties
_pg_char_octet_length |
_pg_char_octet_length(oid, integer) |
postgres |
2 |
int4 |
sql |
|
SELECT CASE WHEN $1 IN (25, 1042, 1043) /* text, char, varchar */ THEN CAST(2^30 AS integer) ELSE null END |
|
|
|
|
SQL
CREATE FUNCTION _pg_char_octet_length(typid oid, typmod integer) RETURNS integer
AS $_$SELECT
CASE WHEN $1 IN (25, 1042, 1043)
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;
List of functions
Function: _pg_datetime_precision(oid, integer)
Properties
_pg_datetime_precision |
_pg_datetime_precision(oid, integer) |
postgres |
2 |
int4 |
sql |
|
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 |
|
|
|
|
SQL
CREATE FUNCTION _pg_datetime_precision(typid oid, typmod integer) RETURNS integer
AS $_$SELECT
CASE WHEN $2 = -1
THEN null
WHEN $1 IN (1083, 1114, 1184, 1266)
THEN $2
WHEN $1 IN (1186)
THEN $2 & 65535
ELSE null
END$_$
LANGUAGE sql IMMUTABLE STRICT;
ALTER FUNCTION information_schema._pg_datetime_precision(typid oid, typmod integer) OWNER TO postgres;
List of functions
Function: _pg_index_position(oid, smallint)
Properties
_pg_index_position |
_pg_index_position(oid, smallint) |
postgres |
2 |
int4 |
sql |
|
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; |
|
|
|
|
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;
List of functions
Function: _pg_keyissubset()
Properties
_pg_keyissubset |
_pg_keyissubset() |
postgres |
2 |
bool |
sql |
|
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)) |
|
|
|
|
SQL
List of functions
Function: _pg_keysequal()
Properties
_pg_keysequal |
_pg_keysequal() |
postgres |
2 |
bool |
sql |
|
select information_schema._pg_keyissubset($1, $2) and information_schema._pg_keyissubset($2, $1) |
|
|
|
|
SQL
List of functions
Function: _pg_numeric_precision(oid, integer)
Properties
_pg_numeric_precision |
_pg_numeric_precision(oid, integer) |
postgres |
2 |
int4 |
sql |
|
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 |
|
|
|
|
SQL
CREATE FUNCTION _pg_numeric_precision(typid oid, typmod integer) RETURNS integer
AS $_$SELECT
CASE $1
WHEN 21 THEN 16
WHEN 23 THEN 32
WHEN 20 THEN 64
WHEN 1700 THEN
CASE WHEN $2 = -1
THEN null
ELSE (($2 - 4) >> 16) & 65535
END
WHEN 700 THEN 24
WHEN 701 THEN 53
ELSE null
END$_$
LANGUAGE sql IMMUTABLE STRICT;
ALTER FUNCTION information_schema._pg_numeric_precision(typid oid, typmod integer) OWNER TO postgres;
List of functions
Function: _pg_numeric_precision_radix(oid, integer)
Properties
_pg_numeric_precision_radix |
_pg_numeric_precision_radix(oid, integer) |
postgres |
2 |
int4 |
sql |
|
SELECT CASE WHEN $1 IN (21, 23, 20, 700, 701) THEN 2 WHEN $1 IN (1700) THEN 10 ELSE null END |
|
|
|
|
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;
List of functions
Function: _pg_numeric_scale(oid, integer)
Properties
_pg_numeric_scale |
_pg_numeric_scale(oid, integer) |
postgres |
2 |
int4 |
sql |
|
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 |
|
|
|
|
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;
List of functions
Function: _pg_truetypid(pg_attribute, pg_type)
Properties
_pg_truetypid |
_pg_truetypid(pg_attribute, pg_type) |
postgres |
2 |
oid |
sql |
|
SELECT CASE WHEN $2.typtype = 'd' THEN $2.typbasetype ELSE $1.atttypid END |
|
|
|
|
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;
List of functions
Function: _pg_truetypmod(pg_attribute, pg_type)
Properties
_pg_truetypmod |
_pg_truetypmod(pg_attribute, pg_type) |
postgres |
2 |
int4 |
sql |
|
SELECT CASE WHEN $2.typtype = 'd' THEN $2.typtypmod ELSE $1.atttypmod END |
|
|
|
|
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;
List of functions
Function: _pg_underlying_index(oid)
Properties
_pg_underlying_index |
_pg_underlying_index(oid) |
postgres |
1 |
oid |
sql |
|
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' |
|
|
|
|
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;
List of functions Procedures
Procedure: _pg_expandarray(IN anyarray, OUT x anyelement, OUT n integer)
Properties
_pg_expandarray |
_pg_expandarray(IN anyarray, OUT x anyelement, OUT n integer) |
postgres |
1 |
record |
sql |
|
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) |
|
|
|
|
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;
List of procedures Tables
Table: sql_features
Properties
Columns
| 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;
List of tables
Table: sql_implementation_info
Properties
sql_implementation_info |
postgres |
|
|
|
|
0 |
|
Columns
| 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;
List of tables
Table: sql_languages
Properties
Columns
| 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;
List of tables
Table: sql_packages
Properties
Columns
| 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;
List of tables
Table: sql_parts
Properties
Columns
| 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;
List of tables
Table: sql_sizing
Properties
Columns
| 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;
List of tables
Table: sql_sizing_profiles
Properties
sql_sizing_profiles |
postgres |
|
|
|
|
0 |
|
Columns
| 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;
List of tables Types
Type: administrable_role_authorizations
Properties
administrable_role_authorizations |
10647 |
postgres |
information_schema.administrable_role_authorizations |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: applicable_roles
Properties
applicable_roles |
10644 |
postgres |
information_schema.applicable_roles |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: attributes
Properties
attributes |
10650 |
postgres |
information_schema.attributes |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: check_constraint_routine_usage
Properties
check_constraint_routine_usage |
10654 |
postgres |
information_schema.check_constraint_routine_usage |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: check_constraints
Properties
check_constraints |
10657 |
postgres |
information_schema.check_constraints |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: column_domain_usage
Properties
column_domain_usage |
10661 |
postgres |
information_schema.column_domain_usage |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: column_privileges
Properties
column_privileges |
10665 |
postgres |
information_schema.column_privileges |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: column_udt_usage
Properties
column_udt_usage |
10669 |
postgres |
information_schema.column_udt_usage |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: columns
Properties
columns |
10673 |
postgres |
information_schema.columns |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: constraint_column_usage
Properties
constraint_column_usage |
10677 |
postgres |
information_schema.constraint_column_usage |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: constraint_table_usage
Properties
constraint_table_usage |
10681 |
postgres |
information_schema.constraint_table_usage |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: data_type_privileges
Properties
data_type_privileges |
10811 |
postgres |
information_schema.data_type_privileges |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: domain_constraints
Properties
domain_constraints |
10684 |
postgres |
information_schema.domain_constraints |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: domain_udt_usage
Properties
domain_udt_usage |
10687 |
postgres |
information_schema.domain_udt_usage |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: domains
Properties
domains |
10690 |
postgres |
information_schema.domains |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: element_types
Properties
element_types |
10815 |
postgres |
information_schema.element_types |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: enabled_roles
Properties
enabled_roles |
10694 |
postgres |
information_schema.enabled_roles |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: information_schema_catalog_name
Properties
information_schema_catalog_name |
10640 |
postgres |
information_schema.information_schema_catalog_name |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: key_column_usage
Properties
key_column_usage |
10697 |
postgres |
information_schema.key_column_usage |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: parameters
Properties
parameters |
10701 |
postgres |
information_schema.parameters |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: referential_constraints
Properties
referential_constraints |
10705 |
postgres |
information_schema.referential_constraints |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: role_column_grants
Properties
role_column_grants |
10709 |
postgres |
information_schema.role_column_grants |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: role_routine_grants
Properties
role_routine_grants |
10713 |
postgres |
information_schema.role_routine_grants |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: role_table_grants
Properties
role_table_grants |
10717 |
postgres |
information_schema.role_table_grants |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: role_usage_grants
Properties
role_usage_grants |
10721 |
postgres |
information_schema.role_usage_grants |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: routine_privileges
Properties
routine_privileges |
10724 |
postgres |
information_schema.routine_privileges |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: routines
Properties
routines |
10728 |
postgres |
information_schema.routines |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: schemata
Properties
schemata |
10732 |
postgres |
information_schema.schemata |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: sequences
Properties
sequences |
10735 |
postgres |
information_schema.sequences |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: sql_features
Properties
sql_features |
10738 |
postgres |
information_schema.sql_features |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: sql_implementation_info
Properties
sql_implementation_info |
10743 |
postgres |
information_schema.sql_implementation_info |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: sql_languages
Properties
sql_languages |
10748 |
postgres |
information_schema.sql_languages |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: sql_packages
Properties
sql_packages |
10753 |
postgres |
information_schema.sql_packages |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: sql_parts
Properties
sql_parts |
10758 |
postgres |
information_schema.sql_parts |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: sql_sizing
Properties
sql_sizing |
10763 |
postgres |
information_schema.sql_sizing |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: sql_sizing_profiles
Properties
sql_sizing_profiles |
10768 |
postgres |
information_schema.sql_sizing_profiles |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: table_constraints
Properties
table_constraints |
10773 |
postgres |
information_schema.table_constraints |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: table_privileges
Properties
table_privileges |
10777 |
postgres |
information_schema.table_privileges |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: tables
Properties
tables |
10781 |
postgres |
information_schema.tables |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: triggered_update_columns
Properties
triggered_update_columns |
10785 |
postgres |
information_schema.triggered_update_columns |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: triggers
Properties
triggers |
10788 |
postgres |
information_schema.triggers |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: usage_privileges
Properties
usage_privileges |
10792 |
postgres |
information_schema.usage_privileges |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: view_column_usage
Properties
view_column_usage |
10795 |
postgres |
information_schema.view_column_usage |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: view_routine_usage
Properties
view_routine_usage |
10799 |
postgres |
information_schema.view_routine_usage |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: view_table_usage
Properties
view_table_usage |
10803 |
postgres |
information_schema.view_table_usage |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types
Type: views
Properties
views |
10807 |
postgres |
information_schema.views |
double |
-1 |
|
|
record_in |
record_out |
record_recv |
record_send |
EXTENDED |
|
SQL
List of types Views
View: administrable_role_authorizations
Properties
administrable_role_authorizations |
postgres |
|
|
|
Columns
| 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;
List of views
View: applicable_roles
Properties
applicable_roles |
postgres |
|
|
|
Columns
| 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;
List of views
View: attributes
Properties
attributes |
postgres |
|
|
|
Columns
| 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;
List of views
View: check_constraint_routine_usage
Properties
check_constraint_routine_usage |
postgres |
|
|
|
Columns
| 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;
List of views
View: check_constraints
Properties
check_constraints |
postgres |
|
|
|
Columns
| 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;
List of views
View: column_domain_usage
Properties
column_domain_usage |
postgres |
|
|
|
Columns
| 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;
List of views
View: column_privileges
Properties
column_privileges |
postgres |
|
|
|
Columns
| 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;
List of views
View: column_udt_usage
Properties
column_udt_usage |
postgres |
|
|
|
Columns
| 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;
List of views
View: columns
Properties
columns |
postgres |
|
|
|
Columns
| 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;
List of views
View: constraint_column_usage
Properties
constraint_column_usage |
postgres |
|
|
|
Columns
| 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;
List of views
View: constraint_table_usage
Properties
constraint_table_usage |
postgres |
|
|
|
Columns
| 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;
List of views
View: data_type_privileges
Properties
data_type_privileges |
postgres |
|
|
|
Columns
| 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;
List of views
View: domain_constraints
Properties
domain_constraints |
postgres |
|
|
|
Columns
| 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;
List of views
View: domain_udt_usage
Properties
domain_udt_usage |
postgres |
|
|
|
Columns
| 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;
List of views
View: domains
Properties
domains |
postgres |
|
|
|
Columns
| 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;
List of views
View: element_types
Properties
element_types |
postgres |
|
|
|
Columns
| 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;
List of views
View: enabled_roles
Properties
enabled_roles |
postgres |
|
|
|
Columns
| 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;
List of views
View: information_schema_catalog_name
Properties
information_schema_catalog_name |
postgres |
|
|
|
Columns
| 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;
List of views
View: key_column_usage
Properties
key_column_usage |
postgres |
|
|
|
Columns
| 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;
List of views
View: parameters
Properties
parameters |
postgres |
|
|
|
Columns
| 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;
List of views
View: referential_constraints
Properties
referential_constraints |
postgres |
|
|
|
Columns
| 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;
List of views
View: role_column_grants
Properties
role_column_grants |
postgres |
|
|
|
Columns
| 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;
List of views
View: role_routine_grants
Properties
role_routine_grants |
postgres |
|
|
|
Columns
| 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;
List of views
View: role_table_grants
Properties
role_table_grants |
postgres |
|
|
|
Columns
| 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;
List of views
View: role_usage_grants
Properties
role_usage_grants |
postgres |
|
|
|
Columns
| 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;
List of views
View: routine_privileges
Properties
routine_privileges |
postgres |
|
|
|
Columns
| 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;
List of views
View: routines
Properties
routines |
postgres |
|
|
|
Columns
| 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;
List of views
View: schemata
Properties
schemata |
postgres |
|
|
|
Columns
| 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;
List of views
View: sequences
Properties
sequences |
postgres |
|
|
|
Columns
| 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;
List of views
View: table_constraints
Properties
table_constraints |
postgres |
|
|
|
Columns
| 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;
List of views
View: table_privileges
Properties
table_privileges |
postgres |
|
|
|
Columns
| 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;
List of views
View: tables
Properties
tables |
postgres |
|
|
|
Columns
| 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;
List of views
View: triggered_update_columns
Properties
triggered_update_columns |
postgres |
|
|
|
Columns
| 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;
List of views
View: triggers
Properties
triggers |
postgres |
|
|
|
Columns
| 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;
List of views
View: usage_privileges
Properties
usage_privileges |
postgres |
|
|
|
Columns
| 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;
List of views
View: view_column_usage
Properties
view_column_usage |
postgres |
|
|
|
Columns
| 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;
List of views
View: view_routine_usage
Properties
view_routine_usage |
postgres |
|
|
|
Columns
| 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;
List of views
View: view_table_usage
Properties
view_table_usage |
postgres |
|
|
|
Columns
| 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;
List of views
View: views
Properties
views |
postgres |
|
|
|
Columns
| 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;
List of views
Server: Server
Properties
Server |
PostgreSQL 8.2.5 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special) |
Databases
Total: 1 database(s) Tablespaces
Total: 2 tablespace(s) Logins
Total: 1 login(s) Tablespaces
Tablespace: pg_default
Properties
List of tablespaces
Tablespace: pg_global
Properties
List of tablespaces Logins
Login: postgres
Properties
List of logins
About
Documentation details