Re: insert sql generated from pgAdmin

Hello Praveen,

You can change the backup options to get INSERT statements as below:
1) Set the format to plain.
[image: Screenshot 2020-12-14 at 11.08.49 AM.png]
2) Set type of objects -> Only data to yes. And set queries -> "Use Column
Inserts" and "Use Insert Commands" to yes. And then click backup.
[image: image.png]

On Sat, Dec 12, 2020 at 4:16 AM Jack Royal-Gordon <jackrg(at)pobox(dot)com> wrote:

> Someone else may be able to clarify further, but I believe that pgbackup
> can write a file that contains insert sql statements in order to recreate
> the contents of the database. You can choose one or more tables and whether
> to include the statements to create the tables (along with many many other
> options).
>
> If you’re talking about exporting the commands that you have typed into a
> pgAdmin query window, you have the option to save the query directly from
> that window (prompted when closing the window, Save icon on button bar).
>
> On Dec 11, 2020, at 2:01 PM, R.R. PRAVEEN RAJA <rrpraveenraja(at)live(dot)com>
> wrote:
>
> Hi Khushboo,
>
> Requirement is to export insert sql statements from pgAdmin4 as csv or
> excel or sql file. Please let me know if this option is available.
>
> Regards,
> PraveenRaja
>
> ------------------------------
> *From:* Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
> *Sent:* Friday, December 11, 2020 9:58 AM
> *To:* R.R. PRAVEEN RAJA <rrpraveenraja(at)live(dot)com>
> *Cc:* pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
> *Subject:* Re: insert sql generated from pgAdmin
>
>
> On Fri, Dec 11, 2020 at 12:32 AM R.R. PRAVEEN RAJA <rrpraveenraja(at)live(dot)com>
> wrote:
>
> Dear Team,
>
> Please let me know if we are able to generate insert sql statements in
> pgadmin as we have option in pg_dump utility.
>
> You can use pg_dump utility from pgAdmin by... Right click on Table >
> Backup.
>
> Regards,
> PraveenRaja
>
>
>

--
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"