Wrong command in shell
- by jask
I have this command in a shell archive:
sh -c $POSTGRESbin'psql -U '$POSTGRESuser' -h localhost -d '$POSTGRESdb' -c "select preview from '$fildCatalog' where preview <>'nodata' and id_registro in (select distinct(id_record) from e3_article_items where id_catalog=2101 and id_article in (select id_article from document_articles where id_document in(select distinct(id_document) from p3_logical_pages where id_logical_page in (select id_logical_page from p3_flatplan_pages where id_edition=1536 and id_logical_page is not null order by cast(pagenumber as numeric)))));"' > $queryFolder$highFile"_"$previewFile;
But in <'nodata' appear an error and I don't know how can I resolve it. The error is:
ERROR: column "nodata" does not exist
LINE 1: select preview from XT_FIJOS where preview <>nodata and id_r...
Can anybody help me ?
Thanks !!
^