Eduardo S. Fontanetti wrote:
How can I do to put a file into the PostgreSQL ? I
have got the contents of file in binary yet and put on
a String on my APP, but when I try to insert it on
postgre, it returns to me:
ERROR: parser: unterminated quoted string at or near
BMæ»' at character 90
If you're
I am using bytea data type and Visual Basic 6.
I saw in another place, that I can insert byte values
in the Postgre with a double backslash, then I used a
function to translate the binary string to ANSI
string. Then I can use: \\001\\010\\047 ...
Somebody could say me if its right?
Eduardo
---
I forgot a little, or better, a big detail, to do this
translating from binary to ANSI of a file with 100Kb,
it will return something like 50 bytes, and this
process is very, very and very slow. Then I need to
use another way.
I've tried to use the Replace native function from the
VB to put a
Eduardo S. Fontanetti wrote:
I forgot a little, or better, a big detail, to do this
translating from binary to ANSI of a file with 100Kb,
it will return something like 50 bytes, and this
process is very, very and very slow. Then I need to
use another way.
I've tried to use the Replace native
Hi,
I would like to know where the query plan build by a sql preprocessor is saved in PostgreSQL. database and how can I show their properties like the date it was build, if it is still valid and so on!
Thanks in advance!
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
I would like to know ifspace disk is free to the Operational Systemduring a standard vacuum (without the full option)?
I found in section "21.1.1 Recovering disk space" of Postgresql 7.4.2 manual something about it.
"The standard form of VACUUM is best used with the goal of maintaining a fairly
Carlos Benkendorf [EMAIL PROTECTED] writes:
I could not clear my doubt. Will the standard form, free disk space to the
operational system or not?
It will release space to the OS if (a) there are one or more completely
empty pages at the end of the table and (b) it is able to get an
exclusive
On Fri, 25 Jun 2004, Carlos Benkendorf wrote:
I would like to know if space disk is free to the Operational System
during a standard vacuum (without the full option)?
I found in section 21.1.1 Recovering disk space of Postgresql 7.4.2 manual
something about it.
The standard form of VACUUM
Thank you at all for yours request
Hey, i have a question about of the uses the joins
in PostgreSQL.
In SQL Server the joins i can use with the simbol(*),
Example:. the right join is
table1.field1 =* table2.field2
In Oracle the joins are with the simbol (+),
Example:. the left join is
=?iso-8859-1?q?Jhonatas=20M.=20Rodr=EDguez?= [EMAIL PROTECTED] writes:
I want to continue with the original idea, how i do a
join without
(table1 LEFT JOIN table2 ON (table1.field1 =
table2.field2)
table2 RIGHT OUTER JOIN table1 ON (table2.field2 =
table1.field1))
else with a simbol (as
On Fri, 25 Jun 2004, [iso-8859-1] Jhonatas M. Rodríguez wrote:
Hey, i have a question about of the uses the joins
in PostgreSQL.
In SQL Server the joins i can use with the simbol(*),
Example:. the right join is
table1.field1 =* table2.field2
In Oracle the joins are with the simbol (+),
On Fri, 25 Jun 2004, [iso-8859-1] Jhonatas M. Rodríguez wrote:
Thank you at all for yours request
Hey, i have a question about of the uses the joins
in PostgreSQL.
In SQL Server the joins i can use with the simbol(*),
Example:. the right join is
table1.field1 =* table2.field2
In
12 matches
Mail list logo
