Answers for "postgres how to get table schema"

postgres read table structure

SELECT column_name, data_type, character_maximum_length
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name ='table_name';

Posted by: Guest on October-21-2021

Code answers related to "postgres how to get table schema"