Re: How do I enabled Windows 10 to be able to run PSQL etc

Hi Rob,

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

And when the table is not there, what is the point of using Alter statement ?

By ‘under postgres’ do you mean owned by Postgres in the public schema or in the postgres database - Please see attached picture - that PGAdmin 4 is using postgres - it is the same username as what I have created and as an access when using runpsql.batch.

Oyeah...does anybody know 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 <robjsargent(at)gmail(dot)com> wrote:

> On Sep 7, 2019, at 8:04 AM, Karen Goh <karenworld(at)yahoo(dot)com> wrote:
>
> Hi Rob,
>
> At pgAdmin 4, it shows I am in postgres/postgres(at)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 - 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 Sargent <robjsargent(at)gmail(dot)com> wrote:
>
>
>
>
> > On Sep 7, 2019, at 5:26 AM, Karen Goh <karenworld(at)yahoo(dot)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 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.
> >
> > 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 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.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 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 then your pgadmin connection 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’s easier for 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 neither windows nor pgadmin
>