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.
SET data_directory TO NewPath;
To show current server configuration setting.
SELECT name, setting, unit, context FROM pg_settings;
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 dbrnd.com, 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.