Downloads
Home   >   mailing lists

Thread: can we create index/constraints in different schema

can we create index/constraints in different schema

From
navneet nikku
Date:
Hi,
   This is working in Oracle but not in postgresql 'CREATE INDEX client.test_1_idx
  ON dbo.test_1 (name);'   . Can we implement this by another way?

Thanks 
Navneet

Re: can we create index/constraints in different schema

From
Michael Paquier
Date:
On Tue, May 14, 2019 at 03:41:37AM -0400, navneet nikku wrote:
>    This is working in Oracle but not in postgresql 'CREATE INDEX
> client.test_1_idx
>   ON dbo.test_1 (name);'   . Can we implement this by another way?

No, it is not possible to define a schema with CREATE INDEX, and an
index gets located in the same schema as its depending table.
--
Michael
Attachment

Re: can we create index/constraints in different schema

From
navneet nikku
Date:
Ok, thanks for the clarification. 
Regards 
Navneet

On Tue, May 14, 2019 at 4:33 AM Michael Paquier <michael@paquier.xyz> wrote:
On Tue, May 14, 2019 at 03:41:37AM -0400, navneet nikku wrote:
>    This is working in Oracle but not in postgresql 'CREATE INDEX
> client.test_1_idx
>   ON dbo.test_1 (name);'   . Can we implement this by another way?

No, it is not possible to define a schema with CREATE INDEX, and an
index gets located in the same schema as its depending table.
--
Michael