On Jan 2, 2012, at 12:00 AM, Andreas Kretschmer wrote:
> vinodh chowdary wrote:
>
>> Hi sir,
>>
>> i am using postgres as database for my project.
>> i want to convert postgres data into excel sheet.
>> is there any way to do it?
>> please reply me.
>
> This should be possible with ODBC.
> (
On Dec 29, 2011, at 7:08 AM, Lars Gustafsson wrote:
> Hi,
>
> I am trying to recover a lot of deleted rows from a database ( pg 8.2.3 ) ,
> not my database, I promise…..
>
> When using the tool pgfsck I get good results, but timestamp is not
> implemented.
>
> When trying to export as int8
On Dec 17, 2011, at 2:21 PM, Stefan Weiss wrote:
> I know, but the problem only occurs when I want to sort by a column
> which hasn't been selected, and thus cannot be referred to by its index.
> For normal (non-union) queries, this is possible:
>
>SELECT relname
> FROM pg_class
> WH
On Dec 7, 2011, at 6:34 AM, Raj Mathur (राज माथुर) wrote:
> Hi,
>
> I'm trying to correlate Call Data Records (CDRs) from two Asterisk
> servers, one of which uses the other for telephony. The data is in
> the tables cdr and cdr2. With some indexes, the query and explain
> result are:
>
> expl
On Oct 25, 2011, at 7:12 AM, alan wrote:
> I'm new to postgres and was wondering how to use EXPLAIN ANALYZE
>
> Can I use the output from ANALYZE EXPLAIN to estimate or predict the
> actual time
> it would take for a given query to return?
>
> I ask because I'm writing a typical web app tha
On Aug 25, 2011, at 1:17 PM, pp...@sapo.pt wrote:
>
> Hello
>
>
> I want to use the function st_offsetCurve but the pgadmin don't have and i
> don't find in the site of pgadmin. CAn anybody send me?
>
> thanks
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make cha
On May 10, 2011, at 9:48 AM, John Fabiani wrote:
> Hi,
> Maybe this is a dumb question but if I have a date field that contains a NULL
> will it show up when I ask for a where date range for the same date field.
>
> Where mydate >= "2011/04/01"::date and mydate<= "2011/04/30"::date
>
> With the
