equal
deleted
inserted
replaced
80 Change password |
80 Change password |
81 =============== |
81 =============== |
82 :: |
82 :: |
83 |
83 |
84 ALTER USER me WITH PASSWORD 'PassWord'; |
84 ALTER USER me WITH PASSWORD 'PassWord'; |
|
85 |
|
86 Monitor connections |
|
87 =================== |
|
88 :: |
|
89 |
|
90 select * from pg_stat_activity; |
85 |
91 |
86 List databases, schemas and tables |
92 List databases, schemas and tables |
87 ================================== |
93 ================================== |
88 |
94 |
89 Default database is ``postgres``. |
95 Default database is ``postgres``. |
178 i.relname |
184 i.relname |
179 order by |
185 order by |
180 t.relname, |
186 t.relname, |
181 i.relname; |
187 i.relname; |
182 |
188 |
|
189 List index usage:: |
|
190 |
|
191 SELECT * FROM pg_stat_all_indexes; |
|
192 SELECT * FROM pg_stat_all_tables; |
|
193 SELECT * FROM pg_stat_user_indexes; |
|
194 SELECT * FROM pg_stat_user_tables; |
|
195 |
|
196 List constraints:: |
|
197 |
|
198 SELECT * FROM pg_constraint; |
|
199 SELECT * FROM pg_constraint WHERE conrelid = (SELECT oid FROM pg_class WHERE relname LIKE 'tblName'); |
|
200 |
|
201 https://www.postgresql.org/docs/current/catalog-pg-constraint.html |
|
202 pg_constraint. |
|
203 |
183 List functions:: |
204 List functions:: |
184 |
205 |
185 \df |
206 \df |
186 |
207 |
187 List triggers:: |
208 List triggers:: |