Re: insert sql generated from pgAdmin

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,

PraveenRaja

---

From: 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 pgAdmin

 

On 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