Tagged Questions
0
votes
2answers
39 views
Error in TEXT field (PostgreSQL) - NHibernate can't read it
I have this entity:
public class Product
{
public virtual long ID { get; set; }
public virtual string Name { get; set; }
public virtual string Description { get; set; }
public virtual ...
1
vote
1answer
131 views
postgresql: reading binary blobs from php
When i've try to read blob data from database, i've something like this:
xffd8ffe000104a46494600010201006000600000...
It's only on windows OS, on linux it works as it should be
sql:
select lob ...
1
vote
1answer
124 views
Modeling PostgreSQL's large objects in Rails
I need to save large objects in the db in my rails app. I think that I can have a table created in SQL as
CREATE TABLE files (
id serial NOT NULL,
name string NOT NULL,
blob_oid oid NUT NULL
)
And ...
0
votes
1answer
713 views
bad value for type long: - Postgresql, Hibernate, Spring
I wanna store an entity(a String + an image) in PostgresQL using Spring MVC and Hibernate
Here is my table. The image is supposed to be the type of oid.
CREATE TABLE document
(
name character ...
0
votes
1answer
118 views
PostgreSQL: empty BLOB over network
A table shows its BLOBs (bytea column) when accessed from pgAdmin III (v 1.12.3) locally (Ubuntu 11.10), but when accessing the PG over network from remote Windows 7 machine using pgAdmin III (v ...
0
votes
1answer
147 views
How can I select and insert BLOB between different databases using python?
I have some SQL Server tables that contain Image data types.
I want to make it somehow usable in PostgreSQL. I'm a python programmer, so I have a lot of learn about this topic. Help?
4
votes
1answer
1k views
How to Store doc, jpeg, pdf files in postgreSQL using java
In a web application I want to store all doc, jpeg, pdf files in postgreSQL database.
I know it can also be done by storing it on file system and storing its path in db, but I am not looking for that ...
3
votes
3answers
323 views
How access a @Lob field from an EJB3 extended persistence context
We're developing a project in JaveEE6, using EJB3 beans and JPA2 annotations.
We have some stateful EJB3 beans that use extended persistence context in order to display the database entities to the ...
0
votes
1answer
330 views
How do you create a BLOB column in rails postgresql database
I'm attempting to store binary data in a database. (postgresql on heroku)
I understand there are two different ways to store binary data in postgresql. A blob and a bytea..
When I create a table ...
heroku
0
votes
1answer
88 views
PostgreSQL how to restore a blob entry to the file system
I want to restore a blob entry to the file system as a file.
How can I do that with PostgreSQL on Linux?
Could you direct me towards an appropriate solution(s)?
Thanks in advance.
0
votes
1answer
709 views
How can one convert an image file stored as a clob into a blob and insert it into a different table?
Using Oracle
How can one convert an image file stored as a clob into a blob and insert it into a different table?
I already have code pulling a blob image out and displaying it on my website but I ...
3
votes
3answers
2k views
Get size of large object in PostgreSQL query?
I would like to obtain the byte size of a blob.
I am using Postgresql and would like to obtain the size using an SQL query. Something like this:
SELECT sizeof(field) FROM table;
Is this possible ...
4
votes
1answer
989 views
Are there performance issues storing files in PostgreSQL?
Is ok storing files like HTML pages, images, PDF, etc in a table in PostgreSQL or it is slow? I read some articles saying that this is not recommended, but I don't know if is true.
And what is better ...
2
votes
3answers
668 views
Storing long binary (raw data) strings
I have a quick question about how to store very long binary strings from a device. We are capturing a raw binary string that is variable in size (from 100k to 800k) and we would like to store these ...
3
votes
2answers
455 views
Racket Server & PostgreSQL - BLOB upload/download without saving to memory or disk
I am trying to make a servlet for the Racket Web Server that would allow a user to upload pictures to the site and display the already uploaded files as images on the same page. I would like to stream ...
