github.com/fragmenta/query@v1.5.3/tests/query_test_pq.sql (about)

     1  /* Database created using psql for tests - query_test */
     2  DROP TABLE pages;
     3  CREATE TABLE pages (
     4      id SERIAL NOT NULL,
     5      title text,
     6      text text,
     7      keywords text,
     8      status integer,
     9      created_at timestamp NOT NULL,
    10      updated_at timestamp NOT NULL,
    11      url text,
    12      summary text
    13  );
    14  
    15  
    16  insert into pages (title,text,keywords,status,created_at,updated_at,url,summary) VALUES('Title 1.','test 1 text','keywords1',100,NOW(),NOW(),'test.example.com','');
    17  insert into pages (title,text,keywords,status,created_at,updated_at,url,summary) VALUES('Title 2','test 2 text','keywords 2',100,NOW(),NOW(),'test.example.com','');
    18  insert into pages (title,text,keywords,status,created_at,updated_at,url,summary) VALUES('Title 3 here','test 3 text','keywords,3',100,NOW(),NOW(),'test.example.com','');