stored_query

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('query.stored_query_id_seq'::regclass)
fieldset.stored_query fieldset_stored_query_fkey R
expression.subquery expression_subquery_fkey R
from_relation.subquery from_relation_subquery_fkey R
order_by_item.stored_query order_by_item_stored_query_fkey C
query_sequence.child_query query_sequence_child_query_fkey C
query_sequence.parent_query query_sequence_parent_query_fkey C
select_item.stored_query select_item_stored_query_fkey C
type text 2147483647 null
use_all bool 1 false
use_distinct bool 1 false
from_clause int4 10 null
from_relation.id stored_query_from_clause_fkey R
where_clause int4 10 null
expression.id stored_query_where_clause_fkey R
having_clause int4 10 null
expression.id stored_query_having_clause_fkey R
limit_count int4 10 null
expression.id stored_query_limit_count_fkey R
offset_count int4 10 null
expression.id stored_query_offset_count_fkey R

Indexes

Constraint Name Type Sort Column(s)
stored_query_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
query_type ((type = ANY (ARRAY['SELECT'::text, 'UNION'::text, 'INTERSECT'::text, 'EXCEPT'::text])))

Relationships