We found corrupt data today in production that cannot be converted to UTF8. We are in the process of coorecting the data values. Thanks for your response.
On 7/19/06, Aaron Bono <[EMAIL PROTECTED]> wrote:
On 7/17/06, adey <[EMAIL PROTECTED]
> wrote:
We recently backed up our production database
postgresql is a dataware housing tool :) what exactly are you looking for?
merlin
On 7/19/06, vamsee movva <[EMAIL PROTECTED]> wrote:
Hello all
could you please tell me if there are any dataware housing tools for
postgresql
Thanks in advance
vamsee
---(end of broadc
Hey Tom,
Here is the query:
DELETE FROM recent_projects WHERE project_id = 3 AND user_id = 139;
And here is the query plan:
Index Scan using pk_recent_projects on recent_projects (cost=0.00..5.81
rows=1 width=6)
Index Cond: ((user_id = 139) AND (project_id = 3))
The table definition is
Hello all,
I'm a newbie. PostgreSQL 8.1.4. Fedora Core 5.
I'm writing a small java application that will import CSV txt files into
my DB. The SQL statement I'm sending to pgsql looks like this:
"INSERT into table (col1,col2,col3) values (to_number(?,
'999'),to_timestamp(?, 'MM/DD/ HH24:MI:
On 7/19/06, Ghislain Bob Hachey <[EMAIL PROTECTED]> wrote:
Hello all,I'm a newbie. PostgreSQL 8.1.4. Fedora Core 5.I'm writing a small java application that will import CSV txt files intomy DB. The SQL statement I'm sending to pgsql looks like this:"INSERT into table (col1,col2,col3) values (to_n
>
> Why use to_number or to_timestamp? I assume you are using setString
> in your prepared statement. In your Java code you can use setNull if
> the value is null and setInt or setLong or setTimestamp if it is not.
> Then you don't need the to_number or to_timestamp.
You're absolutely right.
