forked from lacanoid/pgddl
-
Notifications
You must be signed in to change notification settings - Fork 0
/
manifest.out
96 lines (95 loc) · 4.68 KB
/
manifest.out
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
\pset tuples_only
with
a as (
select oid::regprocedure,obj_description(oid) from pg_proc p where proname like 'ddlx_%'
order by obj_description(oid) is null, cast(oid::regprocedure as text) collate "C"
)
select * from a
;
ddlx_alter(oid,text[]) | Get SQL ALTER statement for any object by object id (post-data)
ddlx_create(oid,text[]) | Get SQL CREATE statement for any object by object id. Includes constraints, triggers, indexes...
ddlx_createonly(oid,text[]) | Get SQL CREATE statement for any object by object id (pre-data)
ddlx_drop(oid,text[]) | Get SQL DROP statement for any object by object id
ddlx_script(oid,text[]) | Get SQL DDL script for any object and dependants by object id
ddlx_script(text,text[]) | Get SQL DDL script for any object and dependants by object name
ddlx_alter_database(oid) |
ddlx_alter_owner(oid) |
ddlx_alter_role(regrole) |
ddlx_alter_role_auth(oid) |
ddlx_alter_sequence(regclass) |
ddlx_alter_table_defaults(regclass) |
ddlx_alter_table_rls(regclass) |
ddlx_alter_table_settings(regclass) |
ddlx_alter_table_storage(regclass) |
ddlx_apropos(text) |
ddlx_banner(text,text,text,text,text) |
ddlx_comment(oid) |
ddlx_create_access_method(oid) |
ddlx_create_aggregate(regproc) |
ddlx_create_amop(oid) |
ddlx_create_amproc(oid) |
ddlx_create_cast(oid) |
ddlx_create_class(regclass,text[]) |
ddlx_create_collation(oid,text[]) |
ddlx_create_constraint(oid) |
ddlx_create_constraints(regclass) |
ddlx_create_conversion(oid) |
ddlx_create_database(oid) |
ddlx_create_default(oid) |
ddlx_create_event_trigger(oid) |
ddlx_create_extension(oid,text[]) |
ddlx_create_foreign_data_wrapper(oid) |
ddlx_create_function(regproc) |
ddlx_create_index(regclass,text[]) |
ddlx_create_indexes(regclass,text[]) |
ddlx_create_language(oid) |
ddlx_create_operator(regoper) |
ddlx_create_operator(regoperator) |
ddlx_create_operator_class(oid) |
ddlx_create_operator_family(oid) |
ddlx_create_policy(oid) |
ddlx_create_publication(oid) |
ddlx_create_role(regrole) |
ddlx_create_rule(oid) |
ddlx_create_rules(regclass) |
ddlx_create_schema(regnamespace,text[]) |
ddlx_create_sequence(regclass,text[]) |
ddlx_create_server(oid,text[]) |
ddlx_create_subscription(oid) |
ddlx_create_table(regclass,text[]) |
ddlx_create_tablespace(oid) |
ddlx_create_text_search_config(regconfig) |
ddlx_create_text_search_dict(regdictionary) |
ddlx_create_text_search_parser(oid) |
ddlx_create_text_search_template(oid) |
ddlx_create_transform(oid) |
ddlx_create_trigger(oid) |
ddlx_create_triggers(regclass) |
ddlx_create_type(regtype,text[]) |
ddlx_create_type_base(regtype) |
ddlx_create_type_domain(regtype) |
ddlx_create_type_enum(regtype) |
ddlx_create_type_range(regtype) |
ddlx_create_type_shell(regtype) |
ddlx_create_user_mapping(oid,text[]) |
ddlx_create_view(regclass,text[]) |
ddlx_definitions(oid,text[]) |
ddlx_describe(regclass) |
ddlx_drop_amop(oid) |
ddlx_drop_amproc(oid) |
ddlx_drop_constraint(oid) |
ddlx_drop_default(oid) |
ddlx_drop_trigger(oid) |
ddlx_get_constraints(regclass) |
ddlx_get_dependants(oid) |
ddlx_get_functions(regproc) |
ddlx_get_indexes(regclass) |
ddlx_get_rules(regclass) |
ddlx_get_triggers(regclass) |
ddlx_grants(oid) |
ddlx_grants(regclass) |
ddlx_grants(regproc) |
ddlx_grants(regrole) |
ddlx_grants_columns(regclass) |
ddlx_identify(oid) |
ddlx_script_parts(oid,text[]) |