PostgreSQL Python Handling BLOB Data

Insert BLOB into a table
1. Create a new database connection to the PostgreSQL database server.
2. Create a new cursor.
3. Execute the INSERT statement with the input values. For BLOB data, use the Binary object of the psycopg module.
4. Call the close() method of the cursor and connection objects to close the connection

Read BLOB in the table
1. Create a new database connection to the PostgreSQL database server.
2. Create a new cursor.
3. Execute the SELECT statement with the input values.
4. Save the BLOB data to a file.
5. Call the close() method of the cursor and connection objects to close the connection.

[shamilpm]

Sir,
Very use full,
Can u pls do this same By using GUI Form.
Using Django or any other
Pls

[shamilpm]

Sir,
In MSSQL can use user defined Types
Is there any user defined Types in POSTGRESQL ?
How can pass data by using user defined types into procedure

[kingstonxavier]

Thanks! Is there any way to read the BLOBs without knowing the file extension?

[devikasaodekar]

Very detailed video. But it is hard to follow without any interaction. Can you please add details of the steps and path details please? Thanks!