I am not able to run the CREATE TABLE AS command in QGIS DB Manager (Win 10, QGIS 3.4.5-Madeira. I am getting the same error in QGIS 2.18 (Win 8).

Query execution error on CREATE TEMP VIEW _tview AS CREATE TABLE VV as SELECT 55 AS FF: 1 - near "CREATE": syntax error

enter image description here Here is the error message in a screenshot:

Actually, I see even the following does not work on my Win 10.

   ID   INT              NOT NULL,
   AGE  INT              NOT NULL,
   SALARY   DECIMAL (18, 2),       

Am I missing something in syntax, or the DB manager is missing something?

  • 4
    In which section in DB Manager are you ? Virtual Layers ? If so, DDL commands are not available. – J. Monticolo Nov 27 '19 at 8:16
  • 1
    It is a Virtual Layer. I see the problem now. – Stat-R Nov 27 '19 at 8:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.