Re: Help with extracting large volumes of records across related tables - Mailing list pgsql-performance

From Paul Thomas
Subject Re: Help with extracting large volumes of records across related tables
Date
Msg-id 20040913131023.A6743@bacon
Whole thread Raw
In response to Help with extracting large volumes of records across related tables  ("Damien Dougan" <damien.dougan@mobilecohesion.com>)
Responses Re: Help with extracting large volumes of records across related tables
Re: Help with extracting large volumes of records across related tables
List pgsql-performance
On 13/09/2004 12:38 Damien Dougan wrote:
> [snip]
> Are there any tools/tricks/tips with regards to extracting large volumes
> of data across related tables from Postgres? It doesnt have to export
> into XML, we can do post-processing on the extracted data as needed -
> the important thing is to keep the relationship between PvA and PvB on a
> row-by-row basis.

Have you considered using cursors?

--
Paul Thomas
+------------------------------+-------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for Business           |
| Computer Consultants         | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+-------------------------------------------+

pgsql-performance by date:

Previous
From: "Damien Dougan"
Date:
Subject: Help with extracting large volumes of records across related tables
Next
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Help with extracting large volumes of records across related tables