SQL: convert backup file from copy format to insert format
- by takeshin
I have a PostgreSQL backup made with PHPPgadmin using Export Copy (instead Copy SQL which is actually what I need).
File contains entries like this:
COPY tablename(id, field) FROM stdin;
...
How to convert this file to SQL format?
INSERT INTO tablename...
I want to use Pgadmin to to import this file using execute SQL command.