php – Migrating to PostgreSQL

Question:

In general, there is a site on symfony, I change the driver to pdo_pgsql, the fixer that creates the default user is faulted.

INSERT INTO user (Usr_Username, Usr_Email,

ERROR: syntax error at or near "user"

In general, the system wants user to be in quotes since there is the same variable

This is how the fixture is written

 $entity = new User();
            $entity->setUsername("root");
            $manager->persist($entity);
 $entity
            ->setPassword("bla")
            ->setEmail("bla@gmail.com")
            ->setFirst("root")
            ->setLast("root")
            ->setOfficePhone("1")
            ->setMobilePhone("1")
            ->setTimeZone("11")
            ->setEnabled(true);
 $manager->flush();

In general, how could this be fixed?

Answer:

In general, I will leave a note for myself, in the User Entity you need to write the name of the table in 3 quotes

/**
 * @ORM\Table(name="""user""")
 */

Further, by analogy, in general, if there are problems, I only had this place.

Scroll to Top