Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== MySQL / Postgres Comparison ====== ===== Table List ===== **MySQL:** <code> SHOW TABLES </code> **Postgres:** <code> SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' ORDER BY table_name </code> ===== Column List ===== **MySQL:** <code> SHOW COLUMNS FROM tbl_name </code> **Postgres:** <code> SELECT column_name, udt_name, is_nullable, character_maximum_length FROM information_schema.columns WHERE table_name = 'tbl_name' </code> ===== Concatenation ===== **MySQL:** <code> SELECT CONCAT(fname, ' ', lname) AS name FROM tbl_name </code> **Postgres:** <code> SELECT fname || ' ' || lname AS name FROM tbl_name </code> docs/mysql/mysql_postgres_comparison.txt Last modified: 2008/08/03 00:25by 127.0.0.1