Ability to check against current DB schema

onyxframework / sql

A delightful SQL ORM ☺️

https://api.onyxframework.com/sql

MIT License

91 stars 7 forks source link

Ability to check against current DB schema #63

Closed vladfaust closed 5 years ago

vladfaust commented 5 years ago

SELECT column_name, udt_name, column_default, is_nullable
FROM information_schema.columns WHERE table_name = 'users';

"id";"int4";"nextval('users_id_seq'::regclass)";"NO"
"about";"text";"";"YES"
"website";"text";"";"YES"
"created_at";"timestamptz";"now()";"NO"
"status";"users_status";"'pending'::users_status";"NO"

vladfaust commented 5 years ago

Closed in favour of @onyxframework/cli-sql-pro