agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Karen Goh <karenworld@yahoo.com>
To: pgsql-sql@lists.postgresql.org
Subject: How do I enabled Windows 10 to be able to run PSQL etc
Date: Sat, 7 Sep 2019 12:26:13 +0000 (UTC)
Message-ID: <207445330.2444743.1567859173939@mail.yahoo.com> (raw)

Hello experts,

Ever since I found out I have a different versions of Postgresql residing in my PC, I have deleted the old version - 10 and 7 altogether and installed version 11.

So, all look good except that I can't use PSQL at all.

Then, I found out that there is a security tied to using PSQL in Windows 10. However, I tried to alter the setting for DESKTOP user to Full-Control I can't find a way to do it. Neither can I find anything from the internet.

Please advise how do I alter the setting so that I can use PSQL freely.  

I had tried to use runpsql.batch after reading a Stackoverflow user advice.

But, when I tried to do some psql comments, it doesn't work.

What is that comment you might ask - which is my next problem - this comment is to allow me to merge a table which I have created in PGAdmin 4 into a schema - membership which has 3 tables there already.

The thing is that I found that the table which I have created, it is not able to appear under the schema - memberships.  But, when I used runpsql.batch, and use /l , it will show up as a table but under postgres.

Now, in my PGAdmin 4, I did not create a user name either, it is also using postgres as user name so why is the table not appear as a table even after I refreshed.

So, I hope someone can tell me the solutions to the above problem.

Thanks & regards,
Karen

view thread (13+ messages)  latest in thread

Message-ID: <207445330.2444743.1567859173939@mail.yahoo.com>
Permalink:  ../207445330.2444743.1567859173939@mail.yahoo.com/
Also on:    postgresql.org/message-id/207445330.2444743.1567859173939@mail.yahoo.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: karenworld@yahoo.com, pgsql-sql@lists.postgresql.org
  Subject: Re: How do I enabled Windows 10 to be able to run PSQL etc
  In-Reply-To: <207445330.2444743.1567859173939@mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox