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 1i6cGb-0001o3-IH for pgsql-sql@arkaria.postgresql.org; Sat, 07 Sep 2019 15:04:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i6cGa-0006kD-37 for pgsql-sql@arkaria.postgresql.org; Sat, 07 Sep 2019 15:04:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i6cGZ-0006NF-FW for pgsql-sql@lists.postgresql.org; Sat, 07 Sep 2019 15:04:43 +0000 Received: from sonic316-11.consmr.mail.bf2.yahoo.com ([74.6.130.121]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1i6cGW-00013i-F4 for pgsql-sql@lists.postgresql.org; Sat, 07 Sep 2019 15:04:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1567868679; bh=xJab0V/1fHc219MPgCbppzKri2XUoKw1JLHzxma/bUc=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject; b=ralSH9anQcnBNLa1ZOtBvn/6wCbV1i/16dMSBJEi9+Im+6FU9RWFWylQ03gm6dZEInDTIY8gDIveteg81jFDoGux/gaMqLyQW4BflsR3M8TZnZkJmav6V7lpSP/QNQrkV2ZSR1lPbqtK1hyvvKy9j22JrjZWs+/GtDEKn34ycs2pXQECpoj5aBOp/xjkM6uPf1dx6RBsifLUaBJRRiTPpxI1AK14PN/qDbz16iFMDVUHp5UQ5LSUJ9tqgyRMO6vM7yBjl3gAjifs27s/RxknsCaQ3fOSxsD7ydfRyL2geyiVVEuemvxuxZYMKlQomH07tfO5farsgXnzPp6jAktN4w== X-YMail-OSG: wMSYICwVM1mysssmJiEsx_qqjOzccRLJyiQG7yWaPuLLQ9WyH6hVod7QC63KfHE RnVmumfUWLd0VyRLkTKpfntKLS5TNRyAJVbfqNpkRgz6wQ52Hd7J9VxmZFLWXmm0iCBiiMTZRXQR qXfTKk6UV4raL9zGYacUdkA3buHsSnvMe5NvwEnsWFYI1ArW5Cj68R4qygr4eBCf51bzxA0d5C80 CctcsKPUMMX6PkIABFFv0y7sLG_0twXRdLgi5qs9lmbwUb961VnzJ3MtJinWxoYQ.pxUrV7UY7gG dJ08.n97y8LKBM.MxnqddiB2GQ5NT.2Id7AdHft1pKUr9j.BZzfdSP0kjjwNaqNne3bnFyppcROp DELGVIALYa.Qct_nSJdaz0WLY8RRtRf4IDz0JYgnsZKxkdHibNByDozENqTrrMvHhDjeXTcx9z7E 5hAZft0JW5Hdw7BiQNB8SMPLXMeHPir1UpAZUGWxCL0ls2Wny1B7LV2NFej3Jh9pEVq.A3S5nW4c O4zrJFKRbvJF1TGU7ueuOt9hjHgMRM2QNHLImUJ5zOpjUbUDNDUAyI_S6vwG157OGvs5q_u7AlkK 1oJVjh_f3jOgwLI81GPyw1yR.f7tSWlJRk1qlsvJ4ZC566N1FK0Dtz_cuGGkpxCT86aawTMhfnFj 0Qk8.S7EKkC28qmpBHXxICkGryvO23DWM1l1BqNjbszdcpMv5JuY6yn3KmUc2M8STAf2Ha2soYuP G0R86VyQCsBvlCPsqN6HiLcy4zovM_y1vuvr_933qwbxa_fZFW6Xa0cNwjXgpynz0QsvqsBW2egk El55hjysNKLnucifYHfgFh5z9DV_0iHi_MF4_8aWdT4mW_WJwcexrqVhuNPwwTzC5QDZ2qWa24Uo 5.u_tAeDEX0vVx5l9HeifXVqW8BEZ3aKZDMy4Y9lS8iPT0dWl4Y5bNvLkFMdFCjkl1.fTBUjbMll 8CzHcVOsNYdjalGRjtPp6gbyL81Cq3orSiy.3JNeLwMvDxpNnETnndQsxOq.G18sKrb9DZtk2dBT w09KsFO2kxhyjtSzkZMxwe9lriLFEA1VsP7bHplTZ5f42Evvx4l_492EMAt9IRFaQmR5RXGPaCBw 8cobvXFL.EqJNoVk6.36bSZkR1Ppvi18x1QaE3wjGXVR6Nx4mny3EEEw1CqArLR2C7nbAWWXYtaw U5s46CuLA47yEYkdpbIwg7MOvTTe1Y7HMYbxZVON3YXUAGpOA0sGUM7MQsw79Euso3vJQl3ksT2w ryP1vPbGa8y7l_yln4PGD3nTd4VU1Xs0nDAgYAiqb1orv2RDCwd9BfAbe6cRK5_0- Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.bf2.yahoo.com with HTTP; Sat, 7 Sep 2019 15:04:39 +0000 Date: Sat, 7 Sep 2019 15:04:34 +0000 (UTC) From: Karen Goh To: Rob Sargent Cc: pgsql-sql@lists.postgresql.org Message-ID: <1282323688.2470443.1567868674196@mail.yahoo.com> In-Reply-To: <27D5F961-0A53-4819-9558-B2C685D0AB30@gmail.com> References: <207445330.2444743.1567859173939@mail.yahoo.com> <27D5F961-0A53-4819-9558-B2C685D0AB30@gmail.com> Subject: Re: How do I enabled Windows 10 to be able to run PSQL etc MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2470442_345708048.1567868674195" Content-Length: 6037 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_2470442_345708048.1567868674195 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Rob, At pgAdmin 4, it shows I am in postgres/postgres@PostgreSQL11 I have created a table there using CREATE public.TABLE follows by name blah= .. When I executed the SQL, it said successful but it didn't appear together i= n the Schema - membership. 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. So, now, How do 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 a= lter it then ? Alter it to what ? On Saturday, September 7, 2019, 10:07:56 PM GMT+8, Rob Sargent wrote: > 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 residing= 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 advic= e. > > 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 comm= ent 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 usi= ng 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 > > 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 pu= blic 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= 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 = table or drop table/create table if that=E2=80=99s easier for you. =20 ------=_Part_2470442_345708048.1567868674195 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Rob,

At pgAdmin 4, it shows I am in postgres= /postgres@PostgreSQL11

I have created a table there using CREATE pub= lic.TABLE follows by name blah..

When I executed the SQL, it said su= ccessful but it didn't appear together in the Schema - membership.
<= br>So, I tried to use membership.TableName but it doesn't allow so I th= ought maybe this is the way Postgesql work - differ from MYSQL.

So, = now, How do 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 Sar= gent <robjsargent@gmail.com> wrote:




> On Sep 7,= 2019, at 5:26 AM, Karen Goh <karenworld@yahoo.com> wrote:
>> Hello experts,
>
> Ever since I found out I have a differ= ent versions of Postgresql residing in my PC, I have deleted the old versio= n - 10 and 7 altogether and installed version 11.
>
> So, all l= ook good except that I can't use PSQL at all.
>
> Then, I f= ound 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 f= reely.
>
> I had tried to use runpsql.batch after reading a St= ackoverflow user advice.
>
> But, when I tried to do some psql = comments, it doesn't work.
>
> What is that comment you mig= ht 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 ha= s 3 tables there already.
>
> The thing is that I found that th= e 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 a= s a table but under postgres.
>
> Now, in my PGAdmin 4, I did n= ot 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

>
>
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 th= e public schema or in the postgres database. If the latter then your pgadmi= n connection settings need the name of the database to use. Your table need= s to be fully qualified by adding the schema name:
create table schema.t= able
You can use the alter table statement to reset the schema for the e= xisting table or drop table/create table if that=E2=80=99s easier for you.<= br>

=20 ------=_Part_2470442_345708048.1567868674195--