EXPORT / IMPORT - Mailing list pgsql-sql

From Freddy Villalba Arias
Subject EXPORT / IMPORT
Date
Msg-id 92EFB0BEDD24E9419E2CD9A2BD35DAEA0439BC@bmsrv001.madrid.bilbomatica.es
Whole thread Raw
Responses Re: EXPORT / IMPORT
Re: EXPORT / IMPORT
List pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial">Hello,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">Is there a simple way to generate an export / import script in PostgreSQL (i.e. a script that
containsINSERT statements for every row in a table) ???</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-GB" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">COPY is NOT a good option (personal opinion).</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">I’m using pgAdmin3 but it does not offer this (quite disappointing, may I
say).</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">Thanx,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">Freddy.</span></font></div>

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: SUM() & GROUP BY
Next
From: Jerome Alet
Date:
Subject: Re: EXPORT / IMPORT