Loading

ERROR: type "binary" does not exist And I create table manually, and

Patel

Hi friends I try to import mysql schema to postgresql by mysql_fdw. I get error like that: ERROR: type "binary" does not exist And I create table manually, and change some data types like binary to bytea. Finally, Run again "import foreign schema" command .. I get same error. Any idea? Thanks.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amira Bedhiafi5y ago
PostgreSQL provides two distinct ways to store binary data. Binary data can be stored in a table using PostgreSQL's binary data type bytea, or by using the Large Object feature which stores the binary data in a separate table in a special format, and refers to that table by storing a value of type OID in your table.
Rajanikant Hawaldar5y ago
SQL types aren't the same across dialects so sometimes you need manual-ish transformations like this