Re: easy way to acquire height / width from images (PNG, JPEG) storedas bytea?

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема Re: easy way to acquire height / width from images (PNG, JPEG) storedas bytea?
Дата
Msg-id CAMjNa7egZo+1H6ztc6OjyeKupkEaxO8ppRmoecj+=SwCNwQ5ng@mail.gmail.com
обсуждение исходный текст
Ответ на easy way to acquire height / width from images (PNG, JPEG) stored asbytea?  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Ответы Re: easy way to acquire height / width from images (PNG, JPEG) storedas bytea?
Список pgsql-general
Дерево обсуждения
Why not extract and store that metadata with the image rather than trying to extract it to filter on at query time? That way you can index your height and width columns to speed up that filtering if necessary.

You may be able to write a wrapper for a command line tool like imagemagic or something so you can call that from a function to determine the size if you did want to stick with extracting that at query time.

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

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: easy way to acquire height / width from images (PNG, JPEG) stored asbytea?
Следующее
От: Ted Toth
Дата:
Сообщение: Re: performance of first exec of prepared statement