## Surafel Temesgen (surafel3000(at)gmail(dot)com):
> Currently we can not moves data from a file to a table based on some
> condition on a certain column
You can:
COPY ( query ) TO 'filename';
There's even an example in the documentation:
https://www.postgresql.org/docs/10/static/sql-copy.html
"To copy into a file just the countries whose names start with 'A':
COPY (SELECT * FROM country WHERE country_name LIKE 'A%') TO '/usr1/proj/bray/sql/a_list_countries.copy';"
Regards,
Christoph
--
Spare Space.