Re: Addons

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(at)commandprompt(dot)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/