How to access the PostgreSQL in Heroku Database as a Service from Windows 10 PC?

Question

I installed the PostgreSQL add-on on the server and then in the Heroku CLI I entered the command heroku pg:psql postgresql-dimensional-16257 --app samar-db for connecting to the database. But it gave the following outcome.

C:\Users\samar>heroku pg:psql postgresql-dimensional-16257 --app samar-db
--> Connecting to postgresql-dimensional-16257
psql (13.2)
WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.

If any further information required for reviewing the problem, I will share them.

The PostgreSQL version in the server is 13.2 – Samar Pratap Singh Mar 18 '21 at 08:55 — Samar Pratap Singh, Mar 18 '21 at 08:55

score 1 · Accepted Answer · answered Mar 18 '21 at 18:02

1

After a deep search in the StackOverflow community, I found the answer to my question. Solution for this question

answered Mar 18 '21 at 18:02

Samar Pratap Singh

471
1
10
29

How to access the PostgreSQL in Heroku Database as a Service from Windows 10 PC?

1 Answers1