On 3/1/25 17:39, Krishnakant Mane wrote:
>
>>> But when I try creating the same immv on the server it says function
>>> create_immv (unknown, unknown ) does not exist.
>>
>> Connect with psql then do:
>>
>> 1) \dx
>> This will show what extensions are installed and in what schema.
>>
>> 2) show search_path;
>>
>> 3) \df *.create_immv
>>
>> Provide the outputs from the above three commands in your response.
See above and provide answers.
--
Adrian Klaver
adrian.klaver@aklaver.com