PostgreSQL commands for creating database, user and table. (Day-6 Part-1)
PostgreSQL, an advanced open-source relational database management system, comes with a powerful interactive terminal known as psql. The psql command-line interface provides database administrators and developers a flexible environment to execute SQL commands and manage databases. Using psql, users can perform various operations such as creating and managing databases, granting and revoking permissions, inspecting schemas, and maintaining database health.
Some essential commands include:
\l to list all available databases.
\c [database_name] to connect to a specific database.
\dt to display all tables within the connected database.
\du to list database roles and their permissions.
\dn+ to inspect schemas and their access privileges.