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;