PostgreSQL connect to database using psql
To connect to the PostgreSQL database server using psql command line, run If you have a PostgreSQL user and password, you can…
PostgreSQL
postgresql.service: The name org.freedesktop.PolicyKit1 was not provided by any .service files
When i restart postgresql, i get following error postgres@vmi465483:~$ systemctl restart postgresql.service Failed to restart postgresql.service: The name org.freedesktop.PolicyKit1 was not provided…
PostgreSQL Export table into CSV file
To export a table into CSV file, run \copy TABLE_NAME to ‘FILE_NAME.csv’ csv header; This will save the CSV file in current…
PostgreSQL List all databases
To list all databases in the PostgreSQL database, first connect to the PostgreSQL database using psql command Now run This will list…
PostgreSQL Create Database
To create a database, run CREATE DATABASE “DB_NAME_HERE”; Creating user, grant permissions CREATE USER USER_NAME_HERE WITH PASSWORD ‘BAPT788HZutBdV’; GRANT ALL PRIVILEGES ON…
PostgreSQL Delete a Database
To delete a PostgreSQL database, run DROP DATABASE DB_NAME; Example DROP DATABASE “odoodb2”;
pg_ctl
pg_ctl is used to start and stop the PostgreSQL server. To start PostgreSQL, run You can also use stop/restart. Back to PostgreSQL