admin-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.
--
Thank
Ajay Kumar
Applications Developer
From: Ashesh Vashi
Sent: Friday, July 31, 2020 5:33 AM
To: Ajay Kumar
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Schema related
On Tue, Jul 28, 2020 at 8:32 PM Ajay Kumar
mailto:kuma...@pwcs.edu>> wrote:
Ashesh,
T
; --
> *From:* Ashesh Vashi
> *Sent:* Friday, July 31, 2020 5:33 AM
> *To:* Ajay Kumar
> *Cc:* pgadmin-supp...@postgresql.org
> *Subject:* Re: Schema related
>
> On Tue, Jul 28, 2020 at 8:32 PM Ajay Kumar wrote:
>
> Ashesh,
>
>
&g
> *From:* Ashesh Vashi
> *Sent:* Sunday, July 26, 2020 3:30 AM
> *To:* Ajay Kumar
> *Cc:* pgadmin-supp...@postgresql.org
> *Subject:* Re: Schema related
>
>
>
>
>
>
>
> On Sat, 25 Jul 2020 at 16:59, Ajay Kumar wrote:
>
> Hi
>
>
>
> I have PG12.3 and
, 2020 3:30 AM
To: Ajay Kumar
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Schema related
On Sat, 25 Jul 2020 at 16:59, Ajay Kumar
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
On Sat, 25 Jul 2020 at 16:59, Ajay Kumar 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 sche
Hi,
In general, when you want to create or access objects in a schema, you need
to write a qualified name consisting of the schema name and object name
separated by a dot in the query tool as shown below,
SELECT * FROM your_schema_name.table_name;
--
Murtuza
On Sat, 25 Jul 2020, 16:59 Ajay Kum
