Geek asks and answers

Play20 ebean generates sql syntax error with postgresql

I am trying to get my play20 application working with postgresql so that I can use and then deploy to Heroku. I have completed this answer .

Basically, I established a connection to the database (therefore, the connection from the local application to the postgresql database in Heroku worked), but I could not initialize the database with the generated 1.sql evolution. But the generated sql did not work because postgresql uses the schema (it should work without the schema anyway, but apparently I'm doing something wrong or the database is something wrong).

create table user (
id                        bigint not null,
email                     varchar(255),
gender                    varchar(1),
constraint pk_user primary key (id));

Led to

ERROR: syntax error at or near "user"
  Position: 14 [ERROR:0, SQLSTATE:42601]

I fixed this with adding a schema to the table name

create table public.user(
  ...
);

, , . sql . , sql- - .

, ?

+5
2

, , , , . User, , :

@Entity
@Table(name = "users")
public class User extends Model {
    ...
}

- . , , RawSql .

, , , , id, .

+8

, - postgresql, . . , "", postgreqsl. .

sql development ? , , "", .

, . :

(, CREATE TABLE myschema.mytable...), .

, . "" , H2 , , - ...

+2

More articles:


All Articles