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 >

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

Procedures with out parameter(Postgresql 11)

Hi, Please let me know how to deal with procedures with out parameter and returning out parameters. Thanks & Regards Navneet maddheshiya