Query statements for all table structures in the PostgreSQL Column

Query statements for all table structures in the PostgreSQL Column

SELECT tablename FROM pg_tables
WHERE tablename not like 'pg %'
AND tablename not like 'SQL _ %'
Order by tablename;

Query the field information of the t_appointment_apply table.
SELECT a. attnum, a. attname AS field, t. typname AS type, a. attlen AS length,
. Atttypmod AS lengthvar,. attnotnull AS notnull from pg_class c, pg_attribute a, pg_type t where c. relname = 't_ appointment_apply 'and. attnum> 0 and. attrelid = c. oid and. atttypid = t. oid