Hi, Ramon,
> 1. how do you create or transfer to another location
> postgres database aside from the initial
> PGDATA=/var/lib/pgsql/data
You must perform an initdb -D /path/to/new/data/directory
and then:
a) set the PGDATA variable either in your shell
environment files (.bashrc, .bash_profile) or at the prompt with
'export PGDATA=/path/to/new/data/directory' or
b) start the postmaster with the -D flag (-D /path/to/....)
> 2. how can a jpeg or bmp file be stored in postgres.
>
Using large objects, a long time have passed since I did that, you
should check the docs (
http://www.postgresql.org/docs/8.1/static/largeobjects.html ) ...
however, are you sure you want to do it that way ?
Hope it helps, feliz navidad ;-)
Best regards
Dario
--
Atte: Dario Brignardello