Ok, thanks for the clarification. Regards Navneet On Tue, May 14, 2019 at 4:33 AM Michael Paquier <mich...@paquier.xyz> 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 >