Storing small image files

Поиск
Список
Период
Сортировка
От Nelson Green
Тема Storing small image files
Дата
Msg-id CAGo-KZm7WWVvikV7f2Pyh8dj53DmwEo3=-WSFDpg16Gby5kjhw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Storing small image files  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-general
Good morning list,

I am designing a system that will have a table for security badges, and we want to store the ID badge photo. These are small files, averaging about 500K in size. We have made the decision to store the image as a BLOB in the table itself for a variety of reasons. However, I am having trouble understanding just how to do that.

The table structures:

CREATE TABLE employee
(
   employee_id                    INTEGER             NOT NULL,
   employee_lastname              VARCHAR(35)         NOT NULL,
   employee_firstname             VARCHAR(35)         NOT NULL,
   employee_mi                    CHAR(1),
   PRIMARY KEY (employee_id)
);

CREATE TABLE security_badge
(
   badge_number                   CHAR(10)            NOT NULL,
   employee_id                    INTEGER             NOT NULL
      REFERENCES employee(employee_id),
   badge_photo                    ????,
   PRIMARY KEY (badge_number)
);

What datatype should I use for the badge_photo (bytea?), and what are the commands to insert the picture accessing the server remotely through psql, and to retrieve the photos as well, please?

Thanks,
Nelson

В списке pgsql-general по дате отправления:

Предыдущее
От: Steve Rogerson
Дата:
Сообщение: Re: Composite fields and the query planner
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Does it make sense to break a large query into separate functions?