Re: UDFs

On Mon, Aug 13, 2007 at 07:36:41PM +0000, jf wrote:
> > usually it's in: <PREFIX>/share/postgresql/contrib/pgcrypto.sql
> > in the database you want to use pgcrypto functions, you simply run this
> > sql (as superuser), and that's all.
> theory# pwd
> /home/jf/postgresql-8.2.4
> theory# cd share
> bash: cd: share: No such file or directory
> theory# pwd
> /home/jf/postgresql-8.2.4
> theory# ls share
> ls: cannot access share: No such file or directory

share of *installed* system. if you compiled with --prefix=/usr/local,
then it would be /usr/local/share/postgresql/...

> theory# find ./ -name pgcrypto.sql
> theory# cd contrib/pgcrypto/
> theory# ls *.sql

if you didn't compile it - it is not built.
simply:
cd contrib/pgcrypto
make
make install
and you should be fine.

i usually compile postgresql in this way:
cd postgre*
./configure --.... some options
make
make install
cd contrib
make
make install

in this way i have all contrib modules compiled.

of course - you dont need all (on the other hand - i strongly suggest
that you get some familiarity with it, as there are some real gems).

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)