10 PostgreSQL Commands for Developers
Windows
Start Postgres SQL Server
PostgreSQL Initialize Database
Navigate to ...\pgsql\bin\ and type the following command
PostgreSQL Create Database
Navigate to ...\pgsql\bin\ and type the following command
PostgreSQL Create User
Navigate to ...\pgsql\bin\ and type the following command
PostgreSQL Create Role
Navigate to ...\pgsql\bin\ and type the following command
Windows
Start Postgres SQL Server
"pg_ctl" -D "<datafolderpath>" -l logfile startPostgreSQL Initialize Database
Navigate to ...\pgsql\bin\ and type the following command
initdb.exe <datafolderpath>
PostgreSQL Create Database
Navigate to ...\pgsql\bin\ and type the following command
createdb databasename<enter>
PostgreSQL Create User
Navigate to ...\pgsql\bin\ and type the following command
createuser username<enter>
PostgreSQL Create Role
Navigate to ...\pgsql\bin\ and type the following command
createuser username<enter>