Ciberterminal Wiki

User Tools

Site Tools

Trace:
postgresql:basic_postgre_sql_querys

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
basic_postgre_sql_querys [2017/08/14 07:53] – [Table grants] dodgerpostgresql:basic_postgre_sql_querys [2018/05/11 15:30] – dodger
Line 1: Line 1:
 +====== [DOC] PostgreSQL basic queries (1) ======
 +
 ====== Section: Description ====== ====== Section: Description ======
 Basic querys for PostgreSQL administration Basic querys for PostgreSQL administration
Line 127: Line 129:
 </code> </code>
  
 +<code sql> 
 +SELECT c.relname, np.nspname, u.usename, c.relkind 
 +FROM pg_class c, 
 +    pg_user u, 
 +    pg_namespace np 
 +WHERE u.usesysid=c.relowner 
 +AND np.oid= c.relnamespace 
 +AND c.relkind IN ('r', 'v') 
 +; 
 +</code>
 ===== list columns in table ===== ===== list columns in table =====