I’ve been experiencing an issue with PostgreSQL after exporting my database using Adminer. The exported SQL file seems to have some problems that cause errors when I try to import it into another PostgreSQL database.

The error message I’m getting is:

Error in query: ERROR: zero-length delimited identifier at or near """"
LINE 1: ...ents_lock_createdAt" ON "public"."patients" USING btree ("")

This error seems to be caused by an empty string “” being used as a column name in a CREATE INDEX statement, which is not valid in PostgreSQL.

Additionally, I’m encountering another error:

Error in query: ERROR: function on_accounting_items_updated() does not exist

This error is due to the PostgreSQL database being unable to find the function on_accounting_items_updated().

I’ve checked the export settings in Adminer and they seem to be correct. I’ve also tried manually inspecting the exported SQL file for any obvious issues, but couldn’t find any.

Here how i exported it. But dont know why when i import the same file after drop db and use it , i encounter many errors

Has anyone else encountered these issues when exporting a PostgreSQL database using Adminer? Any suggestions on how to resolve these errors would be greatly appreciated.