Re: How do I enabled Windows 10 to be able to run PSQL etc - Mailing list pgsql-sql

> On Sep 7, 2019, at 8:04 AM, Karen Goh <karenworld@yahoo.com> wrote:
>
> 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 in the Schema - membership.
>
> So, I tried to use membership.TableName but it doesn't allow so I thought maybe this is the way Postgesql work -
differfrom 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 Sargent <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 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
forDESKTOP 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
Ihave 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
tablenot 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’s ok.
> By ‘under postgres’ do you mean owned by Postgres in the public schema or in the postgres database. If the latter
thenyour pgadmin connection settings need the name of the database to use. Your table needs to be fully qualified by
addingthe 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’s
easierfor you. 
>
Sorry Karen I’m not at my desk or I could give you url. You’ll have to google Postgres alter table command. I use
neitherwindows nor pgadmin 
>