type "efile" does not exist
usmann123706 opened this issue · 1 comments
usmann123706 commented
postgres=# CREATE TABLE external_file.efile_test ( id smallint primary key, the_file efile);
ERROR: type "efile" does not exist
darold commented
The external_file schema must be in your search_path. For example you can proceed as follow but it must be adapted to your current search_path.
SET search_path="$user",public,external_file;