EXPORT / IMPORT
| От | Freddy Villalba Arias |
|---|---|
| Тема | EXPORT / IMPORT |
| Дата | |
| Msg-id | 92EFB0BEDD24E9419E2CD9A2BD35DAEA0439BC@bmsrv001.madrid.bilbomatica.es обсуждение исходный текст |
| Ответы |
Re: EXPORT / IMPORT
Re: EXPORT / IMPORT |
| Список | 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 по дате отправления: