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.

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

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