====== 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>