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*
<http://www.linkedin.com/in/asheshvashi>

On Tue, Sep 1, 2020 at 8:56 AM Ajay Kumar <KUMARAJ(at)pwcs(dot)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(dot)vashi(at)enterprisedb(dot)com>
> *Sent:* Friday, July 31, 2020 5:33 AM
> *To:* Ajay Kumar <KUMARAJ(at)pwcs(dot)edu>
> *Cc:* pgadmin-support(at)postgresql(dot)org <pgadmin-support(at)postgresql(dot)org>
> *Subject:* Re: Schema related
>
> On Tue, Jul 28, 2020 at 8:32 PM Ajay Kumar <KUMARAJ(at)pwcs(dot)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(dot)vashi(at)enterprisedb(dot)com>
> *Sent:* Sunday, July 26, 2020 3:30 AM
> *To:* Ajay Kumar <KUMARAJ(at)pwcs(dot)edu>
> *Cc:* pgadmin-support(at)postgresql(dot)org
> *Subject:* Re: Schema related
>
>
>
>
>
>
>
> On Sat, 25 Jul 2020 at 16:59, Ajay Kumar <KUMARAJ(at)pwcs(dot)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*
> <http://www.linkedin.com/in/asheshvashi>
>
>