Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (1.0)
Subject: Re: How do I enabled Windows 10 to be able to run PSQL etc
From: Rob Sargent <robjsargent@gmail.com>
In-Reply-To: <207445330.2444743.1567859173939@mail.yahoo.com>
Date: Sat, 7 Sep 2019 07:07:49 -0700
Cc: pgsql-sql@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <27D5F961-0A53-4819-9558-B2C685D0AB30@gmail.com>
References: <207445330.2444743.1567859173939@mail.yahoo.com>
To: Karen Goh <karenworld@yahoo.com>
Precedence: bulk


> On Sep 7, 2019, at 5:26 AM, Karen Goh <karenworld@yahoo.com> wrote:
>=20
> Hello experts,
>=20
> Ever since I found out I have a different versions of Postgresql residing i=
n my PC, I have deleted the old version - 10 and 7 altogether and installed v=
ersion 11.
>=20
> So, all look good except that I can't use PSQL at all.
>=20
> Then, I found out that there is a security tied to using PSQL in Windows 1=
0. However, I tried to alter the setting for DESKTOP user to Full-Control I c=
an't find a way to do it. Neither can I find anything from the internet.
>=20
> Please advise how do I alter the setting so that I can use PSQL freely. =20=

>=20
> I had tried to use runpsql.batch after reading a Stackoverflow user advice=
.
>=20
> But, when I tried to do some psql comments, it doesn't work.
>=20
> What is that comment you might ask - which is my next problem - this comme=
nt is to allow me to merge a table which I have created in PGAdmin 4 into a s=
chema - membership which has 3 tables there already.
>=20
> The thing is that I found that the table which I have created, it is not a=
ble to appear under the schema - memberships.  But, when I used runpsql.batc=
h, and use /l , it will show up as a table but under postgres.
>=20
> Now, in my PGAdmin 4, I did not create a user name either, it is also usin=
g postgres as user name so why is the table not appear as a table even after=
 I refreshed.
>=20
> So, I hope someone can tell me the solutions to the above problem.
>=20
> Thanks & regards,
> Karen
>=20
>=20
Without a user everything will be owned by Postgres account but that=E2=80=99=
s ok.=20
By =E2=80=98under postgres=E2=80=99 do you mean owned by Postgres in the pub=
lic schema or in the postgres database. If the latter then your pgadmin conn=
ection settings need the name of the database to use. Your table needs to be=
 fully qualified by adding the schema name:
create table schema.table
You can use the alter table statement to reset the schema for the existing t=
able or drop table/create table if that=E2=80=99s easier for you.=20=