From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
---|---|
To: | Damien Dougan <damien(dot)dougan(at)mobilecohesion(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Help with extracting large volumes of records across related tables |
Date: | 2004-09-13 12:10:23 |
Message-ID: | 20040913131023.A6743@bacon |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 |
+------------------------------+-------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Mischa Sandberg | 2004-09-13 12:58:57 | Re: Help with extracting large volumes of records across related |
Previous Message | Damien Dougan | 2004-09-13 11:38:05 | Help with extracting large volumes of records across related tables |