From: arne@vajhoej.dk   
      
   On 7/6/2025 3:45 PM, Arne Vajhøj wrote:   
   > I am using a little trick. H2 can emulate both PostgreSQL   
   > SQL dialect and PostgreSQL network protocol.   
      
   To avoid some future frustration: it is necessary to   
   create the database and tables in PostgreSQL mode.   
      
   If created normal then trying to access in PostgreSQL mode   
   fails due to some differences in handling of case sensitivity.   
      
   So not:   
      
   $ pipe java -cp /javalib/h2-2_2_220.jar "org.h2.tools.Shell" -url   
   "jdbc:h2:./test;FILE_LOCK=FS;" -user sa -password hemmeligt < ddl.sql   
      
   but:   
      
   $ pipe java -cp /javalib/h2-2_2_220.jar "org.h2.tools.Shell" -url   
   "jdbc:h2:./test;FILE_LOCK=FS;MODE=PostgreSQL;DATABASE_TO_LOWER=true"   
   -user sa -password hemmeligt < ddl.sql   
      
   Arne   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)