Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to Install Extensions

How to Install Extensions

From
Naveen Krishna
Date:
Respected Sir,

    i want to use postgresql DataBase. but when i am trying to execute script it is showing me error in extensions, i tried in many ways but i am not able to execute script, please tell me how to install Extension in postgresql. i am waiting for your kind replay



With Regards
M N Muralikrishna


Re: How to Install Extensions

From
Pavel Stehule
Date:
Hi

2014-10-16 15:27 GMT+02:00 Naveen Krishna <naveen.krishna1991@gmail.com>:
Respected Sir,

    i want to use postgresql DataBase. but when i am trying to execute script it is showing me error in extensions, i tried in many ways but i am not able to execute script, please tell me how to install Extension in postgresql. i am waiting for your kind replay

please, specify a error message? What extension, do you want to install?

first you have to have installed extension on server.

second, you have to register extension in your database by execution of statement CREATE EXTENSION extension_name;

Regards

Pavel Stehule
 



With Regards
M N Muralikrishna



Re: How to Install Extensions

From
Andreas Kretschmer
Date:
Naveen Krishna <naveen.krishna1991@gmail.com> wrote:

> Respected Sir,
>
>     i want to use postgresql DataBase. but when i am trying to execute script
> it is showing me error in extensions, i tried in many ways but i am not able to
> execute script, please tell me how to install Extension in postgresql. i am
> waiting for your kind replay

create extension ...;


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°