Is it possible to generate without schema at hand? #1551
Answered
by
skabbes
orkhanrustamli
asked this question in
Q&A
|
Hi, sqlc is very helpful for me when using for personal projects but I am thinking of how to implement it for my work tasks. Most of them time, the database (all tables and etc) are created by DB engineers, so I do not have schema file at hand. Of course I can ask to get schema file which can be feed to sqlc but I wonder whether it is possible to generate without schema? |
Answered by
skabbes
May 3, 2022
Replies: 1 comment
|
Without the schema information, sqlc cannot know what types each columns is - and therefore it is (basically) impossible to know which data types to use. What I have done in the past for this is to just issue a pg_dump - assuming you have permissions to do so. pg_dump --no-privileges --no-acl --no-owner --schema-only --no-comments --encoding=utf8 postgres://your_db_here |
0 replies
Answer selected by
orkhanrustamli
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Without the schema information, sqlc cannot know what types each columns is - and therefore it is (basically) impossible to know which data types to use.
What I have done in the past for this is to just issue a pg_dump - assuming you have permissions to do so.