Re: can we create index/constraints in different schema
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);' . 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 >
Re: can we create index/constraints in different schema
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 signature.asc Description: PGP signature