On Tue, May 14, 2019 at 4:33 AM Michael Paquier <michael@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