SQL Schema Explorer

How to use SQL Schema Explorer

Inspect real tables, columns, nullability, defaults and primary/unique/foreign key constraints from the PostgreSQL catalog in your selected local workspace.

1. Choose a saved workspace or a sample dataset, then start PostgreSQL.
2. Open Schema explorer and CSV data and select Inspect schema.
3. Import a new CSV table if needed, inspect its columns, and export displayed query rows.

A practical starting point

CSV imports create a new table with text columns so leading zeroes and empty text remain intact. Add appropriate SQL types and constraints explicitly after reviewing your data.

SELECT table_name, column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'public'
ORDER BY table_name, ordinal_position;

Common mistakes

• CSV header and table names must be bounded ASCII SQL identifiers.
• An existing table is never overwritten by the CSV importer.
• CSV exports contain displayed rows only; the result display cap is not a limit on all database work.

Frequently asked questions