Re: [GENERAL] Moving data directory from one server to another

2010-03-28 Thread Ehsan Haq
). Please let me know.   Thanks Ehsan --- On Mon, 3/29/10, Yar Tykhiy y...@barnet.com.au wrote: From: Yar Tykhiy y...@barnet.com.au Subject: Re: [GENERAL] Moving data directory from one server to another To: Ehsan Haq ehsan_ha...@yahoo.com Date: Monday, March 29, 2010, 1:01 AM Hi Ehsan, On Fri, Mar

[GENERAL] Moving data directory from one server to another

2010-03-26 Thread Ehsan Haq
Hi,    I have two Linux servers both having same Hardware architecture one have ES5 and the other having ES4. Both the servers have same version of PostGres installed (8.3). I want to move all my DBs from ES5 server to ES4 server. I have tried the pg_dump but there are a lot of encoding

[GENERAL] definitions of regexp functions required

2010-03-18 Thread Ehsan Haq
Hi,    I am using a relatively older version of Postgres and I need to use the following functions. regexp_matches(), regexp_split_to_array(), and regexp_split_to_table() . Can anybody provide me the definitions of these functions.   Thanks in advance Ehsan

Re: [GENERAL] Getting Out Parameter in the application using libpq

2009-09-12 Thread Ehsan Haq
Moncure mmonc...@gmail.com wrote: From: Merlin Moncure mmonc...@gmail.com Subject: Re: [GENERAL] Getting Out Parameter in the application using libpq To: Ehsan Haq ehsan_ha...@yahoo.com Cc: pgsql-general@postgresql.org Date: Saturday, September 12, 2009, 1:21 PM On Fri, Sep 11, 2009 at 10:30 PM

Re: [GENERAL] Getting Out Parameter in the application using libpq

2009-09-11 Thread Ehsan Haq
: Re: [GENERAL] Getting Out Parameter in the application using libpq To: Ehsan Haq ehsan_ha...@yahoo.com Cc: pgsql-general@postgresql.org Date: Friday, September 11, 2009, 12:08 PM On Fri, Sep 11, 2009 at 12:31 AM, Ehsan Haq ehsan_ha...@yahoo.com wrote: Hi,    I am looking for a way to get the OUT

[GENERAL] Getting Out Parameter in the application using libpq

2009-09-10 Thread Ehsan Haq
Hi,    I am looking for a way to get the OUT parameters of a FUNCTION/PROCEDURE in my application (C++) using C libpq library. I can get the result set of an OUT parameter having REFCURSOR data type through an explicit FETCH ALL from but for OUT parameter of type integer/varchar I dont