Postgres Pro
Downloads
Home   >   mailing lists

Re: exporting and importing .sql in pgAdmin 4 - Mailing list pgadmin-support

From Murtuza Zabuawala
Subject Re: exporting and importing .sql in pgAdmin 4
Date
Msg-id CAKKotZTuZhp0YR9OKN=BSTPAP6JZb8J-fnMfWxTWby+y83zHpA@mail.gmail.com
Whole thread Raw
In response to exporting and importing .sql in pgAdmin 4  (mhmkrnd <mhm.krnd@gmail.com>)
List pgadmin-support
Tree view
Hi,

Have you tried Restore option?

image.png

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



On Thu, Aug 23, 2018 at 2:12 PM mhmkrnd <mhm.krnd@gmail.com> wrote:
m trying to import a table using pgAdmin 4
I backed up the tables by right click on table, then in menu click on
backup, then in Format choice Plain and save file as
postgresql_food_table.sql
The back up process ran successfully
I removed the table
I tried to import it back by using Query Tool in Tool tab. When I tried to
execute it, it gives me this error :
<http://www.postgresql-archive.org/file/t352153/PgAdmin_4_importing_tables_error.png>


Anyone knows what I did wrong? Thanks in advance



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Attachment

pgadmin-support by date:

Previous
From: mhmkrnd
Date:
Subject: exporting and importing .sql in pgAdmin 4
Next
From: Jürgen Spatz
Date:
Subject: Re: pgadmin4 3.2 don't start on windows 10