For a long time, I have used ORM tools to use databases and I didn’t need to deal differences between different databases much. Until now, I have only beaten by following: Character Limit of Identifiers For example oracle limits table names and column names to 30 characters. I have been using ActiveObjects ORM from Atlassian
Tag: Database
Clone a Postgresql Database
May be there are more efficient ways of doing this, but I could only found following procedure: 1) Create a new DB createdb -U db_user new_db_name 2) Dump data from original DB pg_dump -U db_user -Fc original_db_name > dump_file_name 3) Restore to new db pg_restore -U db_user -d new_db_name dump_file_name