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: <1282323688.2470443.1567868674196@mail.yahoo.com>
Date: Sat, 7 Sep 2019 08:49:48 -0700
Cc: pgsql-sql@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <2B0FF25B-F26A-4FA5-9CD6-D58AF5A534EB@gmail.com>
References: <207445330.2444743.1567859173939@mail.yahoo.com>
 <27D5F961-0A53-4819-9558-B2C685D0AB30@gmail.com>
 <1282323688.2470443.1567868674196@mail.yahoo.com>
To: Karen Goh <karenworld@yahoo.com>
Precedence: bulk


> On Sep 7, 2019, at 8:04 AM, Karen Goh <karenworld@yahoo.com> wrote:
>=20
> Hi Rob,
>=20
> At pgAdmin 4, it shows I am in postgres/postgres@PostgreSQL11
>=20
> I have created a table there using CREATE public.TABLE follows by name bla=
h..
>=20
> When I executed the SQL, it said successful but it didn't appear together i=
n the Schema - membership.
>=20
> So, I tried to use membership.TableName but it doesn't allow so I thought m=
aybe this is the way Postgesql work - differ from MYSQL.
>=20
> So, now, How do I add in the table that I want?
>=20
> So, the thing is that it is already showing me I am in postgres, how do I a=
lter it then ? Alter it to what ?
>=20
> On Saturday, September 7, 2019, 10:07:56 PM GMT+8, Rob Sargent <robjsargen=
t@gmail.com> wrote:
>=20
>=20
>=20
>=20
> > On Sep 7, 2019, at 5:26 AM, Karen Goh <karenworld@yahoo.com> wrote:
> >
> > Hello experts,
> >
> > Ever since I found out I have a different versions of Postgresql residin=
g in my PC, I have deleted the old version - 10 and 7 altogether and install=
ed 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.=20=

> >
> > I had tried to use runpsql.batch after reading a Stackoverflow user advi=
ce.
> >
> > 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 com=
ment 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.bat=
ch, 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 us=
ing postgres as user name so why is the table not appear as a table even aft=
er I refreshed.
> >
> > So, I hope someone can tell me the solutions to the above problem.
> >
> > Thanks & regards,
> > Karen
>=20
> >
> >
> Without a user everything will be owned by Postgres account but that=E2=80=
=99s ok.
> By =E2=80=98under postgres=E2=80=99 do you mean owned by Postgres in the p=
ublic schema or in the postgres database. If the latter then your pgadmin co=
nnection settings need the name of the database to use. Your table needs to b=
e 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=
 table or drop table/create table if that=E2=80=99s easier for you.
>=20
Sorry Karen I=E2=80=99m not at my desk or I could give you url. You=E2=80=99=
ll have to google Postgres alter table command. I use neither windows nor pg=
admin
>=20