On Jul 20, 2006, at 5:54 PM, Abu Mushayeed wrote:
1. set client_encoding = 'LATIN1';
2. COPY FROM 'The data gets into the database. The datbase has some inbuilt
functions that translates the data from LATIN1 to UTF8.
The question is it works but is this correct?
Yes, it is correct assum
We just upgraded our database from LAIN1 to UTF8 and some of the data
imports were failing due to character set mismatch. So, after reading the
documentation, here is what we are doing. According to the documentation it
says that the database does automatic characterset conversion. So based on
Hi & help,
I just started my first instance of v814. It's giving these errors in the
logs with archiving. I saw one other post on this in the newsgroup, but my
problem is a littlie different. The WAL files all have a .ready suffix in
the the archive status folder in pg_xlog. None of the
actally i have UNIX time and that is in *1153222974* format. and i m using
select to_timestamp(1153222974);
http://www.postgresql.org/docs/8.1/static/functions-formatting.html
if you're on 8.1.
HTH.
Ben K.
Developer
http://benix.tamu.edu
---(end of broadcast)
hi hubert
actally i have UNIX time and that is in 1153222974 format. and i m using C api to insert this time in a column whose type is timestamp.
so now can u tell me how can i convert it to timestamp and insert into the timestamp column.
On 7/20/06, hubert depesz lubaczewski <[EMAIL PROTEC
On 7/20/06, LiveShell <[EMAIL PROTECTED]> wrote:
Hi all, I want to convert biginteger and integer data type to timestamp data type.Can any body tell me how to convert??
and what is in this biginteger?is it something like:20060720113254::bigintor rather something like "seconds from epoch"?o
Am Donnerstag, 20. Juli 2006 11:26 schrieb LiveShell:
> I want to convert biginteger and integer data type to timestamp
> data type.
That depends mostly on what kind of meaning you intend to attach to an integer
N. If you want seconds since 1970, you could do
x * interval '1 second' +
Hi all, I want to convert biginteger and integer data type to timestamp data type.Can any body tell me how to convert??
