Postgres Pro
Downloads
Home   >   mailing lists

Re: can we create index/constraints in different schema - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: can we create index/constraints in different schema
Date
Msg-id 20190514083338.GB1376@paquier.xyz
Whole thread Raw
In response to can we create index/constraints in different schema  (navneet nikku <navneetnikks@gmail.com>)
Responses Re: can we create index/constraints in different schema  (navneet nikku <navneetnikks@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Edgy Hacker
Date:
Subject: Re: Tab completion for CREATE TYPE
Next
From: navneet nikku
Date:
Subject: Re: can we create index/constraints in different schema