Tell me more ×  I am using Sf 1.4 for a project. I want to
switch from mySQL to PostgreSQL because of technical reasons (I
have written some database extensions, which I need access to in
my queries).  I have trawled the net, but can't seem to find any
info on how to fo this. So far, I have modified my database.yml
file by modifying the database.yml dsn entry as follows:   dsn:
mysql:dbname=##PROJECT_NAME##;host=localhost   dsn:
postgres:dbname=##PROJECT_NAME##;host=localhost  I have also
commented out the mysql specific entries in propel.ini  However,
when I run ./symfony propel:build-sql and checked the generated
SQL, I notice that the SQL generated was MySQL dialect rather
than PostgreSQL.  How do I tell Symfony to generate SQL for
PostgreSQL?  share|improve this question Found the answer here:
–  Homunculus Reticulli Nov 15 '12 at 13:35 If you found an
answer then add it as answer and accept it. It might be helpful
to other users :) –  Michal Trojanowski Apr 15 at 9:24 add
comment   Your Ans