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
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-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
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
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
--
> 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
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
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
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
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
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
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
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
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
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
17 matches
Mail list logo
