Hi,
I have a new postgresql installation done, it has utf-8 encoding.
I have to make a Oracle database migration and it has ISO8859-15 encoding,
should I change postgresql encoding to same Oracle encoding or with utf-8
it should go well?
If I want change postgresql encoding, I have understood that
On 02/08/2015 11:20 AM, Oliver wrote:
Hi,
I have a new postgresql installation done, it has utf-8 encoding.
I have to make a Oracle database migration and it has ISO8859-15
encoding, should I change postgresql encoding to same Oracle encoding or
with utf-8 it should go well?
If I want change post
On Sun, Feb 8, 2015 at 2:20 PM, Oliver wrote:
> If I want change postgresql encoding, I have understood that I should
> reinstall postgresql (I do installation from rpm official binary files for
> red hat)
>
I can't answer your question about whether the encodings need to be the
same, but I'm pr
Partitioning by day would result in less partitions but of course it would
create a "hot" table where all the writes go.
Actually I have thought of an alternative and I'd be interested in your
opinion of it.
I leave the metrics table alone, The current code continues to read and
write from the
I've noticed that when representing lists as JSON, Postgres 9.4 sometimes
outputs spaces after commas, and other times does not.
# SELECT array_to_json(array[1, 2, 3]), json_build_array(1, 2, 3);
array_to_json | json_build_array
---+--
[1,2,3] | [1, 2, 3]
Thi
hi,
How to run dbms_scheduler.create_job in postgres and is it available
postgres..?
any help ,how to use in postgres..?
FYI, i am using postgres 9.3 version
thanks in advance,
Hi ,
i created type on postgres
CREATE TYPE order_list AS (order_id bigint);
it works fine.
then, i try to create a other table type using above created type.
like,
--create or replace type suborder_list_table as table of suborder_list;
this on *oracle *formate
Hi Adrian,
From: "Adrian Klaver"
Subject: Re: [GENERAL] "Ungroup" data for import into PostgreSQL
On 01/15/2015 04:56 PM, Jim Nasby wrote:
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I have a program that
Hi Adrian,
From: "Adrian Klaver"
Subject: Re: [GENERAL] "Ungroup" data for import into PostgreSQL
On 01/15/2015 04:56 PM, Jim Nasby wrote:
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I have a program that
Jim,
I am OP (Karthik)'s colleague. Please see the responses below.
> Your EXPLAIN ANALYZE output doesn't show this taking 30 seconds, it shows it
> taking 90ms. Please provide an EXPLAIN ANALYZE That actually demonstrates the
> problem.
SELECT DISTINCT it.recipient_id FROM iru.iru_tags it WHE
Sorry for the late reply...life interefered...
From: Jim Nasby
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I have a program that uses ODBC to connect to Excel and extract
data using SQL queries. The pro
> I've noticed that when representing lists as JSON, Postgres 9.4 sometimes
> outputs spaces after commas, and other times does not.
Here is a similar test on 9.3:
# select '[1,2,3]'::json::text, '[1, 2, 3]'::json::text;
text | text
-+---
[1,2,3] | [1, 2, 3]
It looks like
On 03/02/15 00:06, David Evans wrote:
I've noticed that when representing lists as JSON, Postgres 9.4
sometimes outputs spaces after commas, and other times does not.
# SELECT array_to_json(array[1, 2, 3]), json_build_array(1, 2, 3);
array_to_json | json_build_array
--
Hi
PostgreSQL doesn't have a dbms_scheduler. If you need it, you can use a
EnterpriseDB - commercial fork with Oracle migration tools. There it is.
You can use a scheduler pgAgent - https://github.com/postgres/pgagent
http://www.pgadmin.org/docs/dev/pgagent.html
Regards
Pavel
2015-02-03 14:16
2015-02-03 13:49 GMT+01:00 Ramesh T :
> Hi ,
> i created type on postgres
> CREATE TYPE order_list AS (order_id bigint);
> it works fine.
>
> then, i try to create a other table type using above created type.
> like,
> --create or replace type suborder_list_tabl
2015-02-08 20:44 GMT+00:00 Adrian Klaver :
> On 02/08/2015 11:20 AM, Oliver wrote:
>
>> Hi,
>> I have a new postgresql installation done, it has utf-8 encoding.
>> I have to make a Oracle database migration and it has ISO8859-15
>> encoding, should I change postgresql encoding to same Oracle encod
2015-02-08 20:50 GMT+00:00 BladeOfLight16 :
> On Sun, Feb 8, 2015 at 2:20 PM, Oliver wrote:
>
>> If I want change postgresql encoding, I have understood that I should
>> reinstall postgresql (I do installation from rpm official binary files for
>> red hat)
>>
>
> I can't answer your question abou
17 matches
Mail list logo
