DATABASE stores_demo

MAIN

    WHENEVER ERROR CONTINUE
    DROP TABLE searchpathschema.searchpathtable
    DROP TABLE searchpathtable
    PREPARE s1 FROM "DROP SCHEMA searchpathschema"
    EXECUTE s1
    WHENEVER ERROR STOP

    CREATE TABLE searchpathtable (id SERIAL, dt DATE)
--    DELETE FROM qx__schema WHERE table_name="searchpathtable"

    PREPARE s2 FROM "CREATE SCHEMA searchpathschema"
    EXECUTE s2

    INSERT INTO searchpathtable(dt) VALUES (TODAY)

    PREPARE s3 FROM "ALTER TABLE searchpathtable SET SCHEMA searchpathschema"
    EXECUTE s3

END MAIN