Ok, thanks for the limits info, but I have that in the manual. Thanks.
But what I really want to know is this:
1) All large objects of all tables inside one DATABASE is kept on only one table. True or false?
Thanks =o)
RodrigoOn 10/25/05, Nörder-Tuitje, Marcus <[EMAIL PROTECTED]> wrote:
o
I
guess, You should check, if a blob field and large object access is
suitable for you - no escaping etc, just raw binary large objects.AFAIK, PQExecParams is not the right solution for You. Refer the "Large object" section:"28.3.5. Writing Data to a Large Object
The functionint
lo_write(PGconn *c
Now this interests me a lot.
Please clarify this:
I have 5000 tables, one for each city:
City1_Photos, City2_Photos, ... City5000_Photos.
Each of these tables are: CREATE TABLE CityN_Photos (location text, lo_id largeobectypeiforgot)
So, what's the limit for these large objects? I heard I coul
I
guess, You should check, if a blob field and large object access is
suitable for you - no escaping etc, just raw binary large objects.AFAIK, PQExecParams is not the right solution for You. Refer the "Large object" section:"28.3.5. Writing Data to a Large Object
The functionint
lo_write(PGconn *c
ot;
regards,
Narcus
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Auftrag von Michael
Fuhr
Gesendet: Dienstag, 18. Oktober 2005 22:47
An: Rodrigo Madera
Cc: pgsql-performance@postgresql.org
Betreff: Re: [PERFORM] Inefficient escape codes.
[Please copy the mailin
Rodrigo wrote:
$$
As I understand it, the client needs to put the data into the server
using a textual-based command. This makes the 5MB data grow up-to 5x,
making it 25MB in the worst case. (Example: 0x01 -> \\001).
My question is:
1) Is there any way for me to send the binary field directly wit
On 18/10/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> [Please copy the mailing list on replies so others can participate
> in and learn from the discussion.]
>
> On Tue, Oct 18, 2005 at 07:09:08PM +, Rodrigo Madera wrote:
> > > What language and API are you using?
> >
> > I'm using libpqxx. A
[Please copy the mailing list on replies so others can participate
in and learn from the discussion.]
On Tue, Oct 18, 2005 at 07:09:08PM +, Rodrigo Madera wrote:
> > What language and API are you using?
>
> I'm using libpqxx. A nice STL-style library for C++ (I am 101% C++).
I've only dabble
On Tue, Oct 18, 2005 at 06:07:12PM +, Rodrigo Madera wrote:
> 1) Is there any way for me to send the binary field directly without needing
> escape codes?
In 7.4 and later the client/server protocol supports binary data
transfer. If you're programming with libpq you can use PQexecParams()
to
Hello there,
This is my first post in the list. I have a deep low-level background
on computer programming, but I am totally newbie to sql databases. I am
using postgres because of its commercial license.
My problem is with storing large values. I have a database that stores
large ammounts of dat
10 matches
Mail list logo
