Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i79RX-0002YU-LL for pgsql-sql@arkaria.postgresql.org; Mon, 09 Sep 2019 02:30:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i79RV-0007V2-MH for pgsql-sql@arkaria.postgresql.org; Mon, 09 Sep 2019 02:30:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i79RV-0007Kn-8R for pgsql-sql@lists.postgresql.org; Mon, 09 Sep 2019 02:30:13 +0000 Received: from mail-io1-xd44.google.com ([2607:f8b0:4864:20::d44]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i79RN-0005Es-Op for pgsql-sql@lists.postgresql.org; Mon, 09 Sep 2019 02:30:12 +0000 Received: by mail-io1-xd44.google.com with SMTP id h144so25199471iof.7 for ; Sun, 08 Sep 2019 19:30:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=w8SeLZjkTULdfetRBPd3bjn1H/u9zCRxmphypBzMquc=; b=tPGoZjJkZcit9rdWe2rjYvvZFNdK4JQkHjO62dORcEBBdnVe4Q+ay5VlyzFnYM9iUw 5OlFAJHtXaQVpKNPFLXZlIW7nmR2uVtLKLv467RKejz7ZliUY43s3DBVjwoIS4JgZuso 2xBtqtJo2H4p6CCWSuU3ComSJnfyApuyc+hM8zpnY8cp6a16vTGQvhzmrMfYWf2U4N1s gQ+sImVGqWF7DafxIIzfCRD4vx3hKR+P+oMPwh8GBycIZZTQe1hNNKy9OYRulwOufqYF WgjWi0HAyM3fPYBF0u1NGGsd6rxvIgiO18LHqko5e404d1yT4s6p/s3Gliy661WEWiBb MthA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=w8SeLZjkTULdfetRBPd3bjn1H/u9zCRxmphypBzMquc=; b=E5qsChqC087lp4H/P22bdGIPaa8b3LniPHyqZQYX7IGTumue0XEYxJttF+Oc10A9Qd wURy7hl2qJ9WsV78kL19I1NrqEAifb7RXr/0hibKmMoXgjOZTAHTBVbnSMVEmJgPdGZr 8VRgw5ZAzZooL0iw/KOlnUoiHABwsxBWcnBXeAxeslJ7kLQBVbEtvbW3eZaAo+FdWeLt RV9HQuyBRft8K4dCmJo3eI/9gG+PecfkokRwGAHQKVINjvAMlL0VQM2cmAs9K3maLuyh THQFl2JQ0FQaRtOYaViVWBgZeXosz/f3PX2PRd7PVtlzVlTgsfqdNkZGNd0TIxEUrh/G Ku2g== X-Gm-Message-State: APjAAAXepR7qVwLadLv+4C4OoXV1ZZhzMfbOdqizRoN1Ujgpc5ANItnH YlAO531Lob5HJx9wV6gewKyW9tPiihbdNQ== X-Google-Smtp-Source: APXvYqwQJw+AdIR5xOk+DEUm1PSWCdtfZEjxvlW3d/x5A4Jw6M29b9xVi4tu6D2+tx/vKknFPMtRyw== X-Received: by 2002:a5d:8f9a:: with SMTP id l26mr18212091iol.26.1567996203348; Sun, 08 Sep 2019 19:30:03 -0700 (PDT) Received: from ?IPv6:2601:681:5500:1e3c:9ce:cafe:4674:627e? ([2601:681:5500:1e3c:9ce:cafe:4674:627e]) by smtp.gmail.com with ESMTPSA id d1sm9846108iok.17.2019.09.08.19.30.02 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 08 Sep 2019 19:30:02 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-EA94AC4D-7B7C-4ED8-AED4-05449921B0FA Mime-Version: 1.0 (1.0) Subject: Re: How do I enabled Windows 10 to be able to run PSQL etc From: Rob Sargent X-Mailer: iPhone Mail (16G77) In-Reply-To: <1179111273.2587909.1567915911716@mail.yahoo.com> Date: Sun, 8 Sep 2019 20:30:01 -0600 Cc: pgsql-sql@lists.postgresql.org Content-Transfer-Encoding: 7bit Message-Id: <53C1E987-E6CD-45D2-8299-4E23D6A6C9D4@gmail.com> References: <207445330.2444743.1567859173939@mail.yahoo.com> <27D5F961-0A53-4819-9558-B2C685D0AB30@gmail.com> <1282323688.2470443.1567868674196@mail.yahoo.com> <2B0FF25B-F26A-4FA5-9CD6-D58AF5A534EB@gmail.com> <1179111273.2587909.1567915911716@mail.yahoo.com> To: Karen Goh List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-EA94AC4D-7B7C-4ED8-AED4-05449921B0FA Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable > On Sep 7, 2019, at 10:11 PM, Karen Goh wrote: >=20 >=20 > Hi Rob, >=20 > Your suggestion to use create table schema.table doesn't work and I have a= lready tried this and exhausted my own solving skill before I posted it here= . >=20 > And when the table is not there, what is the point of using Alter statemen= t ? >=20 > By =E2=80=98under postgres=E2=80=99 do you mean owned by Postgres in the p= ublic schema or in the postgres database - Please see attached picture - tha= t PGAdmin 4 is using postgres - it is the same username as what I have creat= ed and as an access when using runpsql.batch. >=20 > Oyeah...does anybody know how do I access psql in Winodws 10 ? So far, no r= eply here... Please let me know if I should write to the committee or ? >=20 > On Saturday, September 7, 2019, 11:51:23 PM GMT+8, Rob Sargent wrote: >=20 >=20 >=20 >=20 > > On Sep 7, 2019, at 8:04 AM, Karen Goh 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 b= lah.. > >=20 > > When I executed the SQL, it said successful but it didn't appear togethe= r in the Schema - membership. > >=20 > > So, I tried to use membership.TableName but it doesn't allow so I though= t maybe 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= alter it then ? Alter it to what ? > >=20 > > On Saturday, September 7, 2019, 10:07:56 PM GMT+8, Rob Sargent wrote: > >=20 > >=20 > >=20 > >=20 > > > On Sep 7, 2019, at 5:26 AM, Karen Goh wrote: > > > > > > Hello experts, > > > > > > Ever since I found out I have a different versions of Postgresql resid= ing in my PC, I have deleted the old version - 10 and 7 altogether and insta= lled 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 Windo= ws 10. However, I tried to alter the setting for DESKTOP user to Full-Contro= l 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 ad= vice. > > > > > > 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 c= omment is to allow me to merge a table which I have created in PGAdmin 4 int= o a schema - membership which has 3 tables there already. > > > > > > The thing is that I found that the table which I have created, it is n= ot able to appear under the schema - memberships. But, when I used runpsql.b= atch, 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 u= sing postgres as user name so why is the table not appear as a table even af= ter 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= public schema or in the postgres database. If the latter then your pgadmin c= onnection 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 existi= ng table or drop table/create table if that=E2=80=99s easier for you. >=20 > >=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 > > > Karen =46rom the screenshot I think membership is one of two databases on that ser= ver. The other db is called postgres (made by Postgres in almost every datab= ase you create) and I suspect your table definition is in the public schema o= f postgres database. membership has only the default schema which is called p= ublic. I can=E2=80=99t identify any table definitions in the screenshot.=20 I think you need to add =E2=80=9Cmembership=E2=80=9D to your pgadmin connect= ion string= --Apple-Mail-EA94AC4D-7B7C-4ED8-AED4-05449921B0FA Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

On Sep 7, 2019, at 10:11 PM, Karen Goh <karenworld@yahoo.com> wrote:


Hi Rob,

Your suggest= ion to use create table schema.table doesn't work and I have already tried t= his and exhausted my own solving skill before I posted it here.

And w= hen the table is not there, what is the point of using Alter statement ?
=
By =E2=80=98under postgres=E2=80=99 do you mean owned by Postgres in the= public schema or in the postgres database - Please see attached picture - t= hat PGAdmin 4 is using postgres - it is the same username as what I have cre= ated and as an access when using runpsql.batch.

Oyeah...does anybody k= now how do I access psql in Winodws 10 ? So far, no reply here... Please let= me know if I should write to the committee or ?

=
=
= On Saturday, September 7, 2019, 11:51:23 PM GMT+8, Rob Sargent &= lt;robjsargent@gmail.com> wr= ote:

=



> On Sep 7, 2019, at 8:04 AM, Kare= n Goh <karenworld@y= ahoo.com> wrote:
>
> Hi Ro= b,
>
> At pgAdmin 4, it shows I a= m in postgres/postgr= es@PostgreSQL11
>
> I have cr= eated a table there using CREATE public.TABLE follows by name blah..
>
> When I executed the SQL, it said suc= cessful but it didn't appear together in the Schema - membership.
>
> So, I tried to use membership.TableName b= ut it doesn't allow so I thought maybe this is the way Postgesql work - diff= er from MYSQL.
>
> So, now, How d= o I add in the table that I want?
>
= > So, the thing is that it is already showing me I am in postgres, how do= I alter it then ? Alter it to what ?
>
> On Saturday, September 7, 2019, 10:07:56 PM GMT+8, Rob Sargent <= robjsargent@gmail.com= > wrote:
>
>
>
>
> > On Sep 7, 20= 19, at 5:26 AM, Karen Goh <karenworld@yahoo.com> wrote:
> >
> > Hello experts,
> >
> > Ever since I found out I have a different versions of Postg= resql residing in my PC, I have deleted the old version - 10 and 7 altogethe= r and installed version 11.
> >
&g= t; > 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 se= tting for DESKTOP user to Full-Control I can't find a way to do it. Neither c= an I find anything from the internet.
> >
> > Please advise how do I alter the setting so that I can use P= SQL freely.
> >
> > I had t= ried to use runpsql.batch after reading a Stackoverflow user advice.
> >
> > But, when I tried to do som= e 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 PGAdmi= n 4 into a schema - membership which has 3 tables there already.
> >
> > The thing is that I found that t= he table which I have created, it is not able to appear under the schema - m= emberships. 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 a= fter I refreshed.
> >
> > So= , I hope someone can tell me the solutions to the above problem.
> >
> > Thanks & regards,
> > Karen
>
> >> >
> Without a user everything w= ill be owned by Postgres account but that=E2=80=99s ok.
&g= t; 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 t= able schema.table
> You can use the alter table stateme= nt to reset the schema for the existing table or drop table/create table if t= hat=E2=80=99s easier for you.

>
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

>
=
<picture to show postges in PGAdmin4.jpg>
Karen=46rom the screenshot I think membership is one of two databases on that s= erver. The other db is called postgres (made by Postgres in almost every dat= abase you create) and I suspect your table definition is in the public schem= a of postgres database. membership has only the default schema which is call= ed public. I can=E2=80=99t identify any table definitions in the screenshot.=  
I think you need to add =E2=80=9Cmembership=E2=80=9D to you= r pgadmin connection string
= --Apple-Mail-EA94AC4D-7B7C-4ED8-AED4-05449921B0FA--