Addons

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

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/