Re: can we create index/constraints in different schema

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: navneet nikku <navneetnikks(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: can we create index/constraints in different schema
Date: 2019-05-14 08:33:38
Message-ID: 20190514083338.GB1376@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message navneet nikku 2019-05-14 08:34:53 Re: can we create index/constraints in different schema
Previous Message Edgy Hacker 2019-05-14 08:31:17 Re: Tab completion for CREATE TYPE