Common commands for PostgreSQL command-line tools Psql

1. Connect to the server:

Psql-h 192.168.1.88-u username-d DatabaseName

2. Switch the database:

\c dbname

3. List all databases:

\l

4. List all current database tables:

\d

5. List all the fields of the table:

\d TableName

6. List the basic conditions of the table:

\d+ TableName

7. Exit

\q

8. View Help

\?

9. View the index:

\di

10. View the system table:

\dts

11. View the User:

\du or \DG

12. View the View:

\DV or \d+ viewname

Greenplum Management Tips

To view the distribution key for a table: Gpskew-t table_name–c

Common commands for PostgreSQL command-line tools Psql