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@xxxxxxxxxxxxxxxxx> 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/
