Обсуждение: Addons
Hello,
I can't find a list of addons on the website. I'd like to view the list of addons like pgcrypto and download/install some of them into my installation so I can use some of the functions.
And is there any advanced docs on the PL/PGSQL language like how to manipulate strings (string replace, search, split, etc)
Thanks
David
I can't find a list of addons on the website. I'd like to view the list of addons like pgcrypto and download/install some of them into my installation so I can use some of the functions.
And is there any advanced docs on the PL/PGSQL language like how to manipulate strings (string replace, search, split, etc)
Thanks
David
David Legault wrote: > Hello, > > I can't find a list of addons on the website. I'd like to view the list of > addons like pgcrypto and download/install some of them into my installation > so I can use some of the functions. There is www.pgfoundry.org and there is the built in contrib. The built in contrib has the items such as pgcrypto. > > And is there any advanced docs on the PL/PGSQL language like how to > manipulate strings (string replace, search, split, etc) The language doesn't :), PostgreSQL does. Unlike something like Perl (or plPerl), something like replace() uses the PostgreSQL function replace() not a language function. See here: http://www.postgresql.org/docs/8.2/static/functions.html You can call anything in the above link from plpgsql, directly. Sincerely, Joshua D. Drake > > Thanks > > David > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/
I can't seem to be able to change/add builtin contrib items using the installer after it's been installed already. Is there another way to access those modules and install them manually ?
Thanks
Thanks
On 2/17/07, Joshua D. Drake <jd@commandprompt.com> wrote:
David Legault wrote:
> Hello,
>
> I can't find a list of addons on the website. I'd like to view the list of
> addons like pgcrypto and download/install some of them into my installation
> so I can use some of the functions.
There is www.pgfoundry.org and there is the built in contrib. The built
in contrib has the items such as pgcrypto.
>
> And is there any advanced docs on the PL/PGSQL language like how to
> manipulate strings (string replace, search, split, etc)
The language doesn't :), PostgreSQL does. Unlike something like Perl (or
plPerl), something like replace() uses the PostgreSQL function replace()
not a language function. See here:
http://www.postgresql.org/docs/8.2/static/functions.html
You can call anything in the above link from plpgsql, directly.
Sincerely,
Joshua D. Drake
>
> Thanks
>
> David
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
David Legault wrote: > I can't seem to be able to change/add builtin contrib items using the > installer after it's been installed already. Is there another way to access > those modules and install them manually ? There will be installer scripts in $PGDATA/share/ It sounds like you are running Windows so you would be do something like: psql -U postgres database < C:\"Program Files\PostgreSQL\share/contrib/... Joshua D. Drake > > Thanks > > On 2/17/07, Joshua D. Drake <jd@commandprompt.com> wrote: >> >> David Legault wrote: >> > Hello, >> > >> > I can't find a list of addons on the website. I'd like to view the list >> of >> > addons like pgcrypto and download/install some of them into my >> installation >> > so I can use some of the functions. >> >> There is www.pgfoundry.org and there is the built in contrib. The built >> in contrib has the items such as pgcrypto. >> >> > >> > And is there any advanced docs on the PL/PGSQL language like how to >> > manipulate strings (string replace, search, split, etc) >> >> The language doesn't :), PostgreSQL does. Unlike something like Perl (or >> plPerl), something like replace() uses the PostgreSQL function replace() >> not a language function. See here: >> >> http://www.postgresql.org/docs/8.2/static/functions.html >> >> You can call anything in the above link from plpgsql, directly. >> >> Sincerely, >> >> Joshua D. Drake >> >> >> > >> > Thanks >> > >> > David >> > >> >> >> -- >> >> === The PostgreSQL Company: Command Prompt, Inc. === >> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 >> Providing the most comprehensive PostgreSQL solutions since 1997 >> http://www.commandprompt.com/ >> >> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate >> PostgreSQL Replication: http://www.commandprompt.com/products/ >> >> > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/