Thanks Ashesh!! I just wanted to access the particular schema and I couldn't do it using psql, even at the server but I can connect using user postgres.
Thanks again, Ajay ________________________________ From: Ashesh Vashi <ashesh.va...@enterprisedb.com> Sent: Tuesday, September 1, 2020 2:03 AM To: Ajay Kumar <kuma...@pwcs.edu> Cc: pgadmin-supp...@postgresql.org <pgadmin-supp...@postgresql.org> Subject: Re: Schema related You can't set the password for a schema. But - you may not have enough permission to access it. Please take look at 'GRANT<https://www.postgresql.org/docs/9.0/sql-grant.html>' USAGE clause for a schema. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com> http://www.linkedin.com/in/asheshvashi On Tue, Sep 1, 2020 at 8:56 AM Ajay Kumar <kuma...@pwcs.edu<mailto:kuma...@pwcs.edu>> wrote: Ashesh, Is it possible to set up a password for a schema (not public or postgres)? I am trying to connect a DSN in Microstrategy BI tool where I have to connect a particular schema. It gives me authentication error. I can't connect to a particular schema using psql. Any help? Thanks, Ajay Kumar Applications Developer ________________________________ From: Ashesh Vashi <ashesh.va...@enterprisedb.com<mailto:ashesh.va...@enterprisedb.com>> Sent: Friday, July 31, 2020 5:33 AM To: Ajay Kumar <kuma...@pwcs.edu<mailto:kuma...@pwcs.edu>> Cc: pgadmin-supp...@postgresql.org<mailto:pgadmin-supp...@postgresql.org> <pgadmin-supp...@postgresql.org<mailto:pgadmin-supp...@postgresql.org>> Subject: Re: Schema related On Tue, Jul 28, 2020 at 8:32 PM Ajay Kumar <kuma...@pwcs.edu<mailto:kuma...@pwcs.edu>> wrote: Ashesh, The document was very helpful and it worked. Once I use INSERT or COPY command in the ora2pg to generate the sql file, it came as huge file of more than 10gb which makes the pgadmin editor to hang. What is the best practice? Is there a way to insert the data from this generated file without opening the file in the editor? 10 GB is definitely a very huge file. I would suggest you use psql for this operation. -- Thanks, Ashesh Looks like we can’t do it on a schema level. If you point me to a document that will be great. Thanks, Ajay Ajay Kumar Applications Developer Department of Information Technology Prince William County Public Schools From: Ashesh Vashi <ashesh.va...@enterprisedb.com<mailto:ashesh.va...@enterprisedb.com>> Sent: Sunday, July 26, 2020 3:30 AM To: Ajay Kumar <kuma...@pwcs.edu<mailto:kuma...@pwcs.edu>> Cc: pgadmin-supp...@postgresql.org<mailto:pgadmin-supp...@postgresql.org> Subject: Re: Schema related On Sat, 25 Jul 2020 at 16:59, Ajay Kumar <kuma...@pwcs.edu<mailto:kuma...@pwcs.edu>> wrote: Hi I have PG12.3 and am using pgadmin4.21. I created my own schema, right click and went to query tool and tried to create some tables. When I checked, it created all those tables in PUBLIC schema. How can ceate the same in my own schema which I created? Sorry, I don't find any docs online. You can use the search path for the same. Please refer search_path in this documentation: https://www.postgresql.org/docs/9.6/ddl-schemas.html — Ashesh Thanks, Ajay Kumar Applications Developer Prince William County Public Schools -- -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com> http://www.linkedin.com/in/asheshvashi
