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.
Regards,
PraveenRaja
|
On Fri, Dec 11, 2020 at 12:32 AM R.R. PRAVEEN RAJA <[hidden email]> wrote:
You can use pg_dump utility from pgAdmin by... Right click on Table > Backup.
|
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 <[hidden email]>
Sent: Friday, December 11, 2020 9:58 AM To: R.R. PRAVEEN RAJA <[hidden email]> Cc: pgAdmin Support <[hidden email]> Subject: Re: insert sql generated from pgAdmin On Fri, Dec 11, 2020 at 12:32 AM R.R. PRAVEEN RAJA <[hidden email]> wrote:
You can use pg_dump utility from pgAdmin by... Right click on Table > Backup.
|
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).
|
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 <[hidden email]> wrote:
Thanks, Aditya Toshniwal pgAdmin hacker | Sr. Software Engineer | edbpostgres.com "Don't Complain about Heat, Plant a TREE" |
Free forum by Nabble | Edit this page |