Postgres Pro
Downloads
Home   >   mailing lists

Thread: exporting and importing .sql in pgAdmin 4

exporting and importing .sql in pgAdmin 4

From
mhmkrnd
Date:
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

Re: exporting and importing .sql in pgAdmin 4

From
Murtuza Zabuawala
Date:
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