Re: can we create index/constraints in different schema

2019-05-14 Thread navneet nikku
Ok, thanks for the clarification. Regards Navneet On Tue, May 14, 2019 at 4:33 AM Michael Paquier 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);' . Ca

Re: can we create index/constraints in different schema

2019-05-14 Thread Michael Paquier
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

can we create index/constraints in different schema

2019-05-14 Thread navneet nikku
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