Postgres SQL Get Table's Meta Data
select columnname, datatype, charactermaximumlength
from INFORMATIONSCHEMA.COLUMNS where tablename =
{ Insert Any table's name here }
Written by pavanmehta
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Postgres
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#