やり方
select column_name,data_type from information_schema.columns where table_name ='table_name';
![](https://qiita-user-contents.imgix.net/https%3A%2F%2Fcdn.qiita.com%2Fassets%2Fpublic%2Farticle-ogp-background-9f5428127621718a910c8b63951390ad.png?ixlib=rb-4.0.0&w=1200&mark64=aHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTkxNiZoPTMzNiZ0eHQ9cG9zdGdyZXNxbCVFMyU4MSVBN2Rlc2MlRTMlODElOTclRTMlODElOUYlRTMlODElODQlRTMlODElQTglRTMlODElOEQmdHh0LWNvbG9yPSUyMzIxMjEyMSZ0eHQtZm9udD1IaXJhZ2lubyUyMFNhbnMlMjBXNiZ0eHQtc2l6ZT01NiZ0eHQtY2xpcD1lbGxpcHNpcyZ0eHQtYWxpZ249bGVmdCUyQ3RvcCZzPTkyOTc0OTRmOWEzZGUzYTBiNTFhMzg2NzNlOGYwYTFi&mark-x=142&mark-y=112&blend64=aHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTYxNiZ0eHQ9JTQwbmlpX3lhbiZ0eHQtY29sb3I9JTIzMjEyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTM2JnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnM9OTNkMDg1MDE2M2FhYjI4Yzc3YzcwM2QyZjM2YmJmZTc&blend-x=142&blend-y=491&blend-mode=normal&s=d94be5701345b3198188ece344c61104)
postgresqlでdescしたいとき - Qiita
select column_name,data_type from information_schema.columns where table_name ='table_name';
ありがたやー。
最後の’table_name’のとこだけ書き換えて使ってね。
コメント