Thread: 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.
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.
On Sat, Dec 12, 2020 at 4:16 AM Jack Royal-Gordon <jackrg@pobox.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@live.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,PraveenRajaFrom: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Sent: Friday, December 11, 2020 9:58 AM
To: R.R. PRAVEEN RAJA <rrpraveenraja@live.com>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: insert sql generated from pgAdminOn Fri, Dec 11, 2020 at 12:32 AM R.R. PRAVEEN RAJA <rrpraveenraja@live.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
"Don't Complain about Heat, Plant a TREE"