PostgreSQL: Important Database Administrator Commands Part II (PSQL)

In this post, I am sharing some important and basic command for Database Administrator of PostgreSQL and PSQL Console.

Below is an important PSQL command.

# \l : to list all databases
# \? : to list help for all commands
# \h create table : show help with topics
# \d : to list all tables
# \df : to list all functions
# \da : to list all aggregate functions
# \dn : to list all schemas
# \du : to list all users
# \r : to reset the query buffer
# \db : to list all table space

To show current data directory.

To change current data directory and it requires a server restart.
To show current server configuration setting.
Anvesh Patel

Leave a Reply

1 Comment on "PostgreSQL: Important Database Administrator Commands Part II (PSQL)"

Notify of
Sort by:   newest | oldest | most voted

Sweet blog! I found it while surfing around on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Cheers