Postgres-sql Archives

The database name is being accessed by other users Postgres | drop the database with command line in Postgres

dropdb destroys an existing PostgreSQL database. The user who executes this command must be a database superuser or the owner of the database. dropdb is a wrapper around the SQL command DROP DATABASE. There is no effective…

0 Comments

29th November 2021

Database / TipsnTricks

Authentication failed Postgress Commandline | pass the password in Postgres command line

In the Postgres command line, it always prompts a password if the password is not set. We can avoid this in the following way. Before running any Postgres command-line command…

0 Comments

22nd November 2021

Database / TipsnTricks

How to extract year and month from date in PostgreSQL

There are various way to get year and month from date in PostgreSQL. 1. Extract The extract function retrieves subfields such as year or hour from date/time values. source must be a value expression…

0 Comments

2nd August 2021