Re: [GENERAL] Taking lot time

appreactiated ! On Thu, Nov 26, 2015 at 12:04 AM, Adrian Klaver wrote: > On 11/25/2015 07:46 AM, Ramesh T wrote: > > First, please take a look at this: > > https://en.wikipedia.org/wiki/Posting_style > > >> Hi All, >> 9.3 version using pgadmin3 >> >> Que

Re: [GENERAL] Taking lot time

random_page_cost = 5.0 effective_cache_size = 1024MB On Wed, Nov 18, 2015 at 11:12 PM, Adrian Klaver wrote: > On 11/17/2015 04:18 AM, Ramesh T wrote: > >> the query is big it's selecting 20 rows from two table like i mentioned >> above exaplain analyze >> >> what shou

Re: [GENERAL] Taking lot time

the query is big it's selecting 20 rows from two table like i mentioned above exaplain analyze what should i do..?any help On Wed, Nov 4, 2015 at 4:27 AM, Adrian Klaver wrote: > On 11/03/2015 06:42 AM, Ramesh T wrote: > >> I have a Query it taking a lot of time to fetch resu

[GENERAL] Taking lot time

I have a Query it taking a lot of time to fetch results so,explain query gave "Hash Join (cost=55078.00..202405.95 rows=728275 width=418)" " Hash Cond: (itd.tran_id = iad._adj__id)" " -> Seq Scan on inv_detail itd (cost=0.00..40784.18 rows=731029 width=95)" "Filter: (event_type = ANY

Re: [GENERAL] postgres function

;-',4) >0 then 1 else 0 end it's return error like integer need... On Thu, Oct 15, 2015 at 8:50 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Oct 15, 2015 at 10:05 AM, Ramesh T > wrote: > >> '123-987-123' it is not fixed some t

Re: [GENERAL] postgres function

select position('-' in '123-987-123') position --- 4 But I want second occurrence, position - 8 plz any help..? On Thu, Oct 15, 2015 at 12:54 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Oct 14, 2015 at 9:38 AM, R

Re: [GENERAL] postgres function

end with - i.e , i need to find second postition of the variable between the '-' On Thu, Oct 15, 2015 at 6:32 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Oct 15, 2015 at 8:32 AM, Ramesh T > wrote: > >> select position('-' in &#

[GENERAL] postgres function

Hi All, Do we have function like regexp_substr in postgres..? in oracle this function seach the - from 1 to 2 and return result, regexp_substr(PART_CATG_DESC,'[^-]+', 1, 2)

Re: [GENERAL] Format

Nice, thank you. On Tue, Sep 29, 2015 at 11:16 PM, Adrian Klaver wrote: > On 09/29/2015 06:13 AM, Ramesh T wrote: > >> >> >> On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T > <mailto:rameshparnandit...@gmail.com>> wrote: >> >> in my mind to be be

Re: [GENERAL] Format

On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T wrote: > in my mind to be beautiful ,avoid confusion to understand sql query code > > like > > select abcd,cde,rfg,count(*),bcd,cde,rfg,count(*),bcd,cde,rfg,count(*) ; > > if some one written, then newer or code reader understand

[GENERAL] Format

Hi All, How to change sql format to look beautiful and understandable using pgadmin3 or else ther tools for postgres. any help appreciated..

[GENERAL] to pg

CREATE UNIQUE INDEX idx_load_pick ON pick (case picked when picked='y' then load_id else null end ); how can i convert case expressed to postgres..above it is oracle. any help appreciated...

[GENERAL] pgcrypto

Hi, i created extension pgcrypto on public with postgres user.But while trying to use from my own schma suppose qa. when i run digest in function in my qa CREATE OR REPLACE FUNCTION sha1(bytea) returns text AS $$ SELECT encode(digest($1, 'sha1'), 'hex') $$ LANGUAGE SQL STRICT

[GENERAL] postgres 9.3

I have one database and two schemas in that public,preview and role preview automatically i want to connect preview schema with preview role. set search_path to preview. show search_path; .. preview. when disconnect and connect database it's showing $user$:public schema not showing preview. wha

Re: [GENERAL] Import Problem

with out hanging how to open data script of the oracle schema to change the name. On Thu, Sep 17, 2015 at 6:31 PM, Ramesh T wrote: > Actually ,oracle have the *qa *schema i have to import to this schema to > postgres database.But in postgres database already have the *qa *schema.My >

Re: [GENERAL] Import Problem

right.manullay is not possible change name of schema in qa is have 2 gb data when i try to change name of the data scipt is hanged. On Thu, Sep 17, 2015 at 11:54 AM, Venkata Balaji N wrote: > > On Thu, Sep 17, 2015 at 1:27 AM, Ramesh T > wrote: > >> Hi All, >>

[GENERAL] Import Problem

Hi All, I'm using or2pg tool ,I exported data but I have to change the schema import to postgres database.exported data more than gb. Can you please let me know, how to do the change the name in data script..?

[GENERAL] view

HI , I have view .when i try to select view ,it had return select * from art; ERROR: permission denied for relation sub_item SQL state: 42501

Re: [GENERAL] postgres connection

on on port 5432. any help to start server.. On Fri, Aug 7, 2015 at 2:26 PM, Ramesh T wrote: > any help > > On Thu, Aug 6, 2015 at 6:51 PM, Ramesh T > wrote: > >> Hi all, >> I got a problem when i start postgres server. >> like' >&g

Re: [GENERAL] postgres connection

any help On Thu, Aug 6, 2015 at 6:51 PM, Ramesh T wrote: > Hi all, > I got a problem when i start postgres server. > like' >could not connect to the server: connection refused on host > 2.3.421.1 and accepting tcp/ip connection on port 5432. > > any help appreciated.. >

[GENERAL] postgres connection

Hi all, I got a problem when i start postgres server. like' could not connect to the server: connection refused on host 2.3.421.1 and accepting tcp/ip connection on port 5432. any help appreciated..

[GENERAL] pghba.conf

Hi All, I changed in pg_hba.conf like,in postgres 9.3 under linux host replication base_backup_user 127.0.0.1/32 trust after above changes ,restarted it . when i try pgbasebackp getting error like, pg_basebackup: could not connect to server: FATAL: no pg_hba.conf en

[GENERAL] postgres 9.3

I changed archive_command in postgresql.conf and restarted it.postgres 3 installed on linux.connected from putty. after restarted it getting message like -bash-4.1$ service postgres-9.3 start postgres-9.3: unrecognized service but files available at server side.. any help..?

Re: [GENERAL] instr detail

here is the example tks help.. http://stackoverflow.com/questions/2965655/how-to-find-the-first-and-last-occurrences-of-a-specific-character-inside-a-stri On Thu, Jul 30, 2015 at 7:38 PM, Ramesh T wrote: > select position('.' in '.T.homas') > result > >

Re: [GENERAL] instr detail

select position('.' in '.T.homas') result 1 it returns first postion.but I need last occurence of ' . ' . actual result -- 3 any help..?appreciated. On Thu, Jul 30, 2015 at 5:00 AM, Tom Lane wrote: > Melvin Davidson writes: > > Based om the definition of Oracle instr(), the equiva

[GENERAL] instr detail

Hi All, is instr available in postgres 9.3..? in oracle instr('12.32.42','.',-1) ,any help appreciated

Re: [GENERAL] Postgres Recovery

it from server commmand mean from putty is it possible..? i want commands to execute the set to the server without open the postgres.conf...? On Mon, Jul 20, 2015 at 6:23 PM, Michael Paquier wrote: > On Mon, Jul 20, 2015 at 7:00 PM, Ramesh T > wrote: > > Hi All, > > W

[GENERAL] Postgres Recovery

Hi All, What i need to know for postgres recovery..?let me know in detail.

Re: [GENERAL] timestamp check

,'-MM-DD HH24'|| ' '||'MI'||' '||'SS')||' '||(SELECT utc_offset FROM pg_catalog.pg_timezone_names WHERE name=changed_dttimezone), '-MM-DD HH24'||' '||'MI'||' '||'SS')::timestampt

Re: [GENERAL] timestamp check

Yes,But i need to display last digits also [image: Inline image 1] like 1500 08-09-10.738901 On Mon, Jul 13, 2015 at 8:18 PM, Francisco Olarte wrote: > Hi Ramesh: > > On Sun, Jul 12, 2015 at 8:21 AM, Ramesh T > wrote: > >> postgres query >> select current_timesta

Re: [GENERAL] xmltable in postgres like in oracle..?

i got function select regexp_split_to_table('2,1', E',')::bigint thanks On Mon, Jul 13, 2015 at 4:13 PM, Ramesh T wrote: > WITH idtable AS ( > SELECT '2342,8766' id > ) > > select * from inv where id in( > SELECT id > FROM idtable) &g

Re: [GENERAL] xmltable in postgres like in oracle..?

y row from temp table? On Sun, Jul 12, 2015 at 5:38 PM, Ramesh T wrote: > xml table is the oracle function ..thank you sir > > On Sat, Jul 11, 2015 at 11:04 PM, Adrian Klaver > wrote: > >> On 07/11/2015 08:32 AM, Ramesh T wrote: >> >>> Hi, >>>

Re: [GENERAL] timestamp check

any help..? On Sun, Jul 12, 2015 at 11:51 AM, Ramesh T wrote: > postgres query > select current_timestamp- > TO_TIMESTAMP(to_char(DATE1, '-MM-DD HH24'|| ' '||'MI'||' '||'SS')||' > '||(SELECT utc_offset FROM pg_cat

Re: [GENERAL] xmltable in postgres like in oracle..?

xml table is the oracle function ..thank you sir On Sat, Jul 11, 2015 at 11:04 PM, Adrian Klaver wrote: > On 07/11/2015 08:32 AM, Ramesh T wrote: > >> Hi, >>is xmltable available in postgres..?,if not please give me a >> advice to replace the xmtable in po

Re: [GENERAL] timestamp check

okay,i'm executing a query from pgadmin3. i want display time with timezone.But above query displaying date and time not timezone... On Sat, Jul 11, 2015 at 9:34 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Jul 10, 2015 at 8:54 AM, Ramesh T > wrot

Re: [GENERAL] timestamp check

gres query..i thnk something wrong. is it..? any help apprictiated. On Sat, Jul 11, 2015 at 11:12 PM, Adrian Klaver wrote: > On 07/10/2015 05:54 AM, Ramesh T wrote: > >> >> select current_timestamp-to_timestamp(to_char(current_date,'-MM-DD >> HH24'||'

[GENERAL] xmltable in postgres like in oracle..?

Hi, is xmltable available in postgres..?,if not please give me a advice to replace the xmtable in postgres..?

[GENERAL] timestamp check

select current_timestamp-to_timestamp(to_char(current_date,'-MM-DD HH24'||':'||'MI'||':'||'SS')||' '||(SELECT utc_offset FROM pg_catalog.pg_timezone_names WHERE name='US/Eastern'),'-MM-DD HH24'||':'||'MI'||':'||'SS')::timestamptz; it's not displaying timezone..any help..?

Re: [GENERAL] regexp_matches for digit

nice i'm looking for this,i thought digit don't work in postgres.. thanks On Thu, Jul 9, 2015 at 10:21 PM, Chris Mair wrote: > > Hi, > > in oracle regexp_like(entered > > date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i') > > > > for postgres i have regexp_matches ,But i need how

[GENERAL] regexp_matches for digit

Hi, in oracle regexp_like(entered date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i') for postgres i have regexp_matches ,But i need how to match [:digit:] in postgres when we pass date..? any help

Re: [GENERAL] Functions

thank you it's helpfull On Fri, May 8, 2015 at 7:43 PM, Adrian Klaver wrote: > On 05/08/2015 01:56 AM, Ramesh T wrote: > >> Hi All, >>I want move functions from onedatabase to other database in same host >> on windows 7 and installed postgres version is 9

[GENERAL] Functions

Hi All, I want move functions from onedatabase to other database in same host on windows 7 and installed postgres version is 9.4.I'm using pgadmin3 tool. any help..?

[GENERAL]

Hi all, as i mentioned above i have function called delete parts can i mention select deleteparts(); or c:\programfiles\9.4\pgagent\check.sql in this path check.sql contain to delete parts.i placed query select deleteparts(); when click run now job,it returns statistics failed and etc/

Re: [GENERAL] Pgagent

ian Klaver wrote: > On 04/13/2015 07:22 AM, Ramesh T wrote: > >> Hi, >> in steps>definition-> >> do >> $body$ >> begin >> perform delete_empty_parts(); >> end; >> $body$ >> >> delete_empty_parts is the function >> >&

[GENERAL] Pgagent

Hi all, i have a function to delete data from table.Where i need to place function in pgagent.in definition section can i select SQL or BATCH ..? or else any other method.? Any Help..

Re: [GENERAL] Pgagent

7;m running function on particular database and selected today dates.. but function wasn't executed. let me know how to set it function in pgagent.. On Mon, Apr 13, 2015 at 7:26 PM, Adrian Klaver wrote: > On 04/13/2015 06:53 AM, Ramesh T wrote: > >> Hi all, >> i h

Re: [GENERAL] Stalled post to pgsql-general

..? On Fri, Apr 3, 2015 at 3:50 PM, wrote: > Your message to pgsql-general has been delayed, and requires the approval > of the moderators, for the following reason(s): > > The author (Ramesh T ) > is not a member of any of the restrict_post groups. > > If you do not wish t

Re: [GENERAL]

nd-schedules-programatically-with-pgagent > > regards > > Pavel Stehule > > 2015-04-03 11:27 GMT+02:00 Ramesh T : > >> Hi , >> How to create job in pgAgent.Where I need to place script in >> pgAgent..any help >> >> Advanced thanks... >> >> >

[GENERAL]

Hi , How to create job in pgAgent.Where I need to place script in pgAgent..any help Advanced thanks...

Re: [GENERAL] stack builder

I had installed on Linux.re-install postgres for stack builder ..? cron is their ,but I am new to this cron and is this method for job schedulers in postgres. On Wed, Apr 1, 2015 at 8:39 PM, Adrian Klaver wrote: > On 04/01/2015 07:59 AM, Ramesh T wrote: > >>Hi, >>

[GENERAL] stack builder

Hi all, I didn't selected stack builder at the time of installation of postgres.Any help how to add* application stack builder* to existed postgres.

Re: [GENERAL] stack builder

Hi, I had installed pgadmin3 but not selected stackbuilder ,let me know how to add stackbuilder to pgadmin3 for additional addons. On Wed, Apr 1, 2015 at 7:15 PM, Adrian Klaver wrote: > On 04/01/2015 06:22 AM, Ramesh T wrote: > >> Hi all, >>

[GENERAL] xml

Hi all, SELECT xmlagg(xmlelement( name actor, xmlattributes(first_name) )ORDER BY actor_id,',')from actor; the above code return following result, [image: Inline image 1] Question : i want retrieve result from above XML result like

[GENERAL]

hi all, I am using postgres 9.4 on windows 7. i want import that backup sql file into postgres schema. i googled i got copy, but when i ran in windows COPY actor FROM 'c:\users\venu\downloads\sakila-data.sql'; ERROR: invalid input syntax for integer: "" CONTEXT: COPY actor, line 1,

[GENERAL] rules

it is in postgres i need to convert into oracle CREATE RULE payment_insert_p2007_04 AS ON INSERT TO payment WHERE (new.payment_date >= '2007-04-01'::timestamp without time zone) DO INSTEAD INSERT INTO payment_p2007_04 (payment_id)VALUES (1); in oracle format i used google i got BEGIN DBMS_MACAD

[GENERAL]

CREATE AGGREGATE group_concat(text) ( SFUNC = _group_concat, STYPE = text ); is it availabe in oracle..?

Re: [GENERAL] dbmsscheduler

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 GMT

Re: [GENERAL] postgres cust types

convert oracle function into postgres format any help..? thanks in advance, On Mon, Feb 9, 2015 at 11:39 AM, Pavel Stehule wrote: > > > 2015-02-03 13:49 GMT+01:00 Ramesh T : > >> Hi , >> i created type on postgres >> CREAT

Re: [GENERAL] Collection

i solved my problem using string_agg in tab_to_string ex:- select string_agg(s.Rnumber ::text,',' )AS number On Fri, Feb 13, 2015 at 10:40 PM, Raymond O'Donnell wrote: > On 13/02/2015 13:13, Ramesh T wrote: > > cast(COLLECT (r_id) as num) in oracle.. > > >

[GENERAL] Collection

cast(COLLECT (r_id) as num) in oracle.. is their *collect *function in postgres plpgsql?or any alternate for this..? thanks in advance,

[GENERAL] dbmsscheduler

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,

[GENERAL] postgres cust types

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

Re: [GENERAL] pg_dump

is their any other method to clone database,other then pgadmin and pgdump.. if is their option pls let me know.. On Wed, Dec 17, 2014 at 4:35 PM, Ramesh T wrote: > > problem solved, > > C:\Program Files\pgadmin\bin>pg_dump -U postgres host -p port -C -f > c:\bb\db_1 db_2 &g

Re: [GENERAL] pg_dump

wrote: > On 12/16/2014 08:17 AM, Ramesh T wrote: > >> >> C:\Program Files\pgAdmin III\1.14>pg_dump -U postgres -p 5432 -C -f >> c:\backup\db_2.dump db_1; >> pg_dump: [archiver (db)] connection to database "db_1;" >> >> failed: coul >> d not

Re: [GENERAL] pg_dump

problem solved, C:\Program Files\pgadmin\bin>pg_dump -U postgres host -p port -C -f c:\bb\db_1 db_2 then to import i used psql On Wed, Dec 17, 2014 at 10:44 AM, Ramesh T wrote: > > Please let me know what happend inside ..? > > > On Wednesday, December 17, 2014, Ramesh T &g

Re: [GENERAL] pg_dump

Please let me know what happend inside ..? On Wednesday, December 17, 2014, Ramesh T wrote: > > I'm installed pgadmin 3 on windows I'm trying to connect server.the server > is on Linux.now I'm trying pgdump from windows from using putty connected > to Linux Postgr

Re: [GENERAL] pg_dump

yes 5432..? On Tue, Dec 16, 2014 at 9:25 PM, Adrian Klaver wrote: > > On 12/16/2014 07:52 AM, Ramesh T wrote: > CCing list. > > 1. >> -bash-4.1$ pg_dump -C -Fp -f C:\backup\db_1.dump db_2 >> >> how to export and where i can save export file >> > >

[GENERAL] pg_dump

hi, i need to export a file the database postgres pg_dump -U postgres -C -Fp -f c:/backup/db2.dump db_1; where i can run pg_dump please send me details i want to export db_1 to db2 i got an error below postgres=# pg_dump -U postgres -C -Fp -f c:/backup/db_2.dump db_1; ERROR: syntax error at o

[GENERAL] phppgadmin

hello, any guidelines is their how to use these tool..? not home site.. http://phppgadmin.kattare.com/phppgadmin/...:)

Re: [GENERAL] phppgadmin

tell me good guidelines for phppgadmin..? On Thu, Nov 6, 2014 at 8:54 PM, Ramesh T wrote: > hello, > any guidelines is their how to use these tool..? > not home site.. > http://phppgadmin.kattare.com/phppgadmin/...:) >

Re: [GENERAL] stackbuilder

any help.. On Tue, Sep 9, 2014 at 4:06 PM, Ramesh T wrote: > Hi, > > I had installed pgadmin3 but not selected stackbuilder ,let me know > how to add stackbuilder to pgadmin3 for additional addons.. > > thanks, > ram > > >

[GENERAL] stackbuilder

Hi, I had installed pgadmin3 but not selected stackbuilder ,let me know how to add stackbuilder to pgadmin3 for additional addons.. thanks, ram

Re: [GENERAL] Deletion

know.. On Thu, Aug 28, 2014 at 1:20 AM, Adrian Klaver wrote: > On 08/27/2014 11:59 AM, Ramesh T wrote: > >> >> In oracle I ran the deletion script to clean up the particular database >> using custid.custid is the parameter .&&1 is used in the oracle Inthe >> s

Re: [GENERAL] Deletion

n script ... On Wednesday, August 27, 2014, Adrian Klaver wrote: > On 08/27/2014 08:24 AM, Ramesh T wrote: > >> any help... >> > > Honestly, this is basic programming/scripting. I would suggest picking up > an introductory programming book to get the basics down. > In t

[GENERAL] Deletion

Hi, I have deletion script to delete particular cust from database.I was saved a file name with custde.sql.i need to run from command line like putty tool..But have a problem example : delete from part where part.custid=$1; when i ran custde.sql from putty tool db=#\i custde.sql it

Re: [GENERAL] POWA tool

i downloaded But where i need to unzip powa-REL_1_1.zip i'm using putty tool remote server.. -bash-4.1$ unzip powa-REL_1_1.zip -bash: unzip: command not found On Tue, Aug 26, 2014 at 12:55 AM, Raghu Ram wrote: > > On Fri, Aug 22, 2014 at 4:40 PM, Ramesh T > wrote: >

Re: [GENERAL] POWA tool

How to include pg_stat_statements in postgres.conf.powa is need it. any help.. thanks, On Wed, Aug 20, 2014 at 11:51 PM, Ramesh T wrote: > yes, > > in my postgres.conf pg_stat_statements is not their needs powa is > released 19 aug. > > > On Wed, Aug 20, 2014 at 10:17 P

Re: [GENERAL] POWA tool

yes, in my postgres.conf pg_stat_statements is not their needs powa is released 19 aug. On Wed, Aug 20, 2014 at 10:17 PM, Raghu Ram wrote: > On Wed, Aug 20, 2014 at 10:08 PM, Raymond O'Donnell wrote: > >> On 20/08/2014 16:41, Ramesh T wrote: >> > Hello, >>

[GENERAL] POWA tool

Hello, when i ran following query, postgres=# SELECT * FROM pg_stat_statements; ERROR: relation "pg_stat_statements" does not exist LINE 1: SELECT * FROM pg_stat_statements; i need to install POWA..i got powa.zip please let me know how

[GENERAL] pgbadger download

can any one send me link pgbadger 6 for me .. advance thanks,

Re: [GENERAL] pgcluu

where need to install Test-Harness-3.32. or ExtUtis/MakeMaker.pm in pg cluu -2.0 folder or /usr/local/lib64/perl.. please let me know advance thanks.. On Tue, Aug 12, 2014 at 3:20 PM, Ramesh T wrote: > Hi, > I don't have the root permission for yum. > secondly

Re: [GENERAL] pgcluu

Harness > > or downloaded the tar package and install it > > http://search.cpan.org/~leont/Test-Harness-3.32/lib/Test/Harness.pm > > I hope this help you. > > David > > > On 08/11/2014 08:52 AM, Ramesh T wrote: > > Hello , > > I specified correct metho

Re: [GENERAL] pgcluu

/lib64/per l5 /usr/share/perl5) at Makefile.PL line 142. wheni trying test Harness it is also not installing.. let me know how to fix issue..? thanks, rao On Sat, Aug 9, 2014 at 9:43 AM, Adrian Klaver wrote: > On 08/08/2014 06:40 AM, Ramesh T wrote: > >> Hi, >>

[GENERAL] pgcluu

Hi, i want install pgcluu on postgres 9.3 and i'm putty tool to connect pg database when i ran . tar xzf pgcluu-2.0.tar.gz cd pgcluu-2.0.tar/ perl Makefile.PL make && sudo make install it's return like.. bash-4.1$ tar xzf pgcluu-2.0.tar.gz tar (c

[GENERAL] {xml}

Hello, when i ran following query on postgres 9.3, SELECT xmlagg(xmlelement(name e,part_id||',')) from part; result .. {xml} how to get part_id's..? please let me know .. advance thanks, R..

[GENERAL] Postgres Performence

Hello, How to improve performence of postgres 9.3 database.And also in oracle web based Enterprise manger is available,in postgres any tool their to monitor and change. please let me know performence related info to my postgres 9.3 database.and any tools which are free and pay. thanks,

[GENERAL] TZ_OFFSET

Hello, select TZ_OFFSET ('US/Eastern') from dual ; it's returning in oracle -- -04:00 but in postgres select TZ_OFFSET ('US/Eastern'); its'returning like function tz_offset('us/Eastern') does not exist; let me know how to solve issue

Re: [GENERAL] tab_to_sting

ringcheck(string_agg(part_id::text,':')) FROM qa.part its returnfunction( text)does'nt exist let me know how solve issue.. thanks, On Thu, Jul 24, 2014 at 10:42 PM, Adrian Klaver wrote: > On 07/24/2014 08:03 AM, Ramesh T wrote: > >> I have try >> select strin

Re: [GENERAL] tab_to_sting

need to add explicit type casts. i thought string_agg and array_agg same, is it right..? On Thu, Jul 24, 2014 at 8:19 PM, Adrian Klaver wrote: > On 07/24/2014 07:46 AM, Ramesh T wrote: > >> i ran the \df string_agg is their >> >> but retuns like >> ERROR: fun

Re: [GENERAL] tab_to_sting

need to add explicit type casts. On Thu, Jul 24, 2014 at 8:00 PM, Adrian Klaver wrote: > On 07/24/2014 07:22 AM, Ramesh T wrote: > >> SELECT >> qa.tab_to_largestringcheck(cast(array_agg(part_id)as >> t_varchar2_tab),':')FROM qa.part >> >> when

Re: [GENERAL] tab_to_sting

i need it please let me know thanks in advance, On Thu, Jul 24, 2014 at 7:26 PM, Adrian Klaver wrote: > On 07/24/2014 05:54 AM, Ramesh T wrote: > >> >> CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); >> / >> >> CREATE OR REPLACE

Re: [GENERAL] tab_to_sting

SELECT qa.tab_to_largestringcheck(cast(array_agg(part_id)as t_varchar2_tab),':')FROM qa.part when i replace string_agg it's return does not exit, need to enable string_agg ..?i think is predefined right On Thu, Jul 24, 2014 at 7:47 PM, Ramesh T wrote: > postgres 9.3 &g

Re: [GENERAL] tab_to_sting

.3 thanks in advance, ramesh On Thu, Jul 24, 2014 at 6:24 PM, Ramesh T wrote: > > CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); > / > > CREATE OR REPLACE FUNCTION tab_to_string (p_varchar2_tab IN > t_varchar2_tab, >

Re: [GENERAL] tab_to_sting

.? i need this one please let me know.. thanks in advance , ramesh On Thu, Jul 24, 2014 at 2:11 AM, Adrian Klaver wrote: > On 07/23/2014 09:12 AM, Ramesh T wrote: > >> Hi, >> >> SELECT hr.tab_to_largestring(CAST(COLLECT(cust_name) AS >> t_varchar2_tab))

[GENERAL] tab_to_sting

Hi, SELECT hr.tab_to_largestring(CAST(COLLECT(cust_name) AS t_varchar2_tab)) AS employees FROM hr.customer when i run function for table column values to single row function name is hr.tab_to_largestring this code from oracle it return like function collect(character varying)

Fwd: [GENERAL] Need r_constraint_name

-- Forwarded message -- From: Ramesh T Date: Tue, Jul 22, 2014 at 7:50 PM Subject: Re: [GENERAL] Need r_constraint_name To: Adrian Klaver Just i'm retriving the constraint_name when i enter child_table_name for inner query and that constraint name is checking parent_tab

Re: [GENERAL] Need r_constraint_name

e as above .. but i want check "r_constraint_name" instead of "constraint_name" in outer statement in above code.. please let me know.. thanks in advance, ramesh On Tue, Jul 22, 2014 at 7:52 AM, Adrian Klaver wrote: > On 07/19/2014 12:26 PM, Ramesh T wrote: >

[GENERAL] Need r_constraint_name

Hi, In oracle got constraint details using user_constraint, But in postgres how to get the r_constraint_name,constraint_name of the particular table...? mainly i need r_constraint_name on table.. how to get it?please let me know

[GENERAL] cursor return null

Hello, in postgres function (id bigint ),the following code not return any value with artNums ,But when i do select statement ony it's output the values with out include cursor i.e,cursor problem ..? please let me know what should i do to getvalues from cursor, but i dont where i mis

[GENERAL] performance monitoring/tuning

Hi, How performance monitoring/tuning on postgres..? please let me know some links to learn, ex-query performence, i need it .. thanks in advance, ramesh

  1   2   >