| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | artis <artis(at)c4(dot)lv> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: pgadmin3 |
| Date: | 2008-12-30 10:59:17 |
| Message-ID: | 4959FF05.6070808@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
On 30/12/2008 10:14, artis wrote:
> I would like to ask - isn't there any "normal" way to export data from
> table to file in format, that would be suitable for importing into other
> db, the same table????
Not sure what you mean by "normal"....two ways come to mind, though
neither involve pgAdmin:
- Use the COPY command to dump the data to a CSV file.
- Use pg_dump to dump the table, with (I think) the -d option to do so
as INSERT commands.
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arnaud Alves | 2008-12-30 16:35:16 | Campo numeric |
| Previous Message | artis | 2008-12-30 10:14:38 | pgadmin3 |