Anuroop Challa

 How to check database and database owner information on psql:  You can check with \list command  example: testsub=> \list                                              List of databases       Name      |   Owner   | Encoding |     Collate     |      Ctype      |       Access privileges ----------------+-----------+----------+-----------------+-----------------+--------------------------------  testdb             | testuser | UTF8     | en_US.UTF-8     | en_US.UTF-8     |

  How to check connected user on psql  : \conninfo example: testsub=> \conninfo You are connected to database "testsub" as user "sub" on host "localhost" (address "127.0.0.1") at port "5432".

Extracting DDL of Objects in PostgreSQL(get table ddl in PostgreSQL) =================================================== 2 Ways to get DDL of objects in PostgreSQL 1.  The utility pg_dump is used to dump the DDL. 2.  Can get the DDL just by running \d. 1.  The utility pg_dump is used to dump the DDL. Table ddl for  testtable from  TESTDB $ pg_dump -d  TESTDB  -s -t  testtable Table ddl for  testtable from  TESTDB written in to file ddl.sql $ pg_dump -d TESTDB -s -T testtable -f ddl.sql Table ddls for  all ables from from  TESTDB $ pg_dump -d  TESTDB  -s 2.  Can get the DDL just by running \d. TESTDB =# \d+  testtable