Understanding Database Schema | Dataford Interview Questions

What is a database schema?

Using PostgreSQL metadata, write a query that demonstrates the structure of the machine_assets table. Return one row for each column, including its name, data type, nullability, and position.

Output

Columns: column_name, data_type, is_nullable, and ordinal_position
Include only columns belonging to machine_assets in the public schema
Return one row per table column, ordered by ordinal_position ascending

Schema

information_schema.columns

Column	Type	Description
table_schema	VARCHAR	Name of the schema containing the table
table_name	VARCHAR	Name of the table
column_name	VARCHAR	Name of the table column
data_type	VARCHAR	SQL data type of the column
is_nullable	VARCHAR	Whether the column allows NULL values
ordinal_position	INT	One-based position of the column in the table

Your question is Understanding Database Schema. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem