SQL

SQL

Convert PostgreSQL Table Schema to Markdown

WITH schema_info AS (
    SELECT column_name, data_type, is_nullable
    FROM information_schema.columns
    WHERE table_name = 'account'
)
SELECT '| Column Name | Data Type | Null/Not Null |'
UNION ALL
SELECT '|-------------|-----------|---------------|'
UNION ALL
SELECT '| ' || column_name || ' | ' || data_type || ' | ' ||
       CASE
           WHEN is_nullable = 'YES' THEN 'Yes'
           ELSE 'No'
       END || ' |'
FROM schema_info;