can we create index/constraints in different schema
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
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
Ok, thanks for the clarification.
Regards
Navneet
On Tue, May 14, 2019 at 4:33 AM Michael Paquier <michael@paquier.xyz> wrote:
Show quoted text
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