English 中文(简体)
Where does pg_lo_write store its contents?
原标题:

There is a function in our system that writes a file to a postgres BLOB, the function is pg_lo_write, our system uses PHP, ADODB and PostgreSQL.

What I would like to know is where is this data stored, is it a file in a postgres directory, in a table?

Many thanks!

Answer Information

Thanks to Ben Fransen for the answer, the BLOB is in fact stored in the pg_largeobject table. I m using pgAdmin and the table is hidden from view, however it can be accessed using a query.

SELECT * FROM pg_largeobject WHERE LOID = 123456
最佳回答

Correct me if I m wrong but as far as i know when you are storing files in a database they are stored as binary data. The binary value of your file is stored in your BLOB field. When you are trying to get that file the binary value is then reconstructed to the original file.

问题回答

For future reference the relevant sections in the PostgreSQL manual:

Chapter 31. Large Objects, 31.2. Implementation Features.

Chapter 44. System Catalogs, 44.23. pg_largeobject.





相关问题
摘录数据

我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。

Postgres dump of only parts of tables for a dev snapshot

On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...

How to join attributes in sql select statement?

I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.

What text encoding to use?

I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...

SQL LIKE condition to check for integer?

I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...

热门标签