| 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 |