postgresql
SELECT datname FROM pg_database WHERE datistemplate = false; SELECT table_name FROM information_schema.tables WHERE table_schema='public' AND table_type='BASE TABLE'; SELECT column_name , data_type , udt_name FROM information_schema.column…
SELECT datname FROM pg_database ;
SELECT column_name ,data_type ,udt_name ,character_maximum_length ,is_nullable ,is_identity FROM information_schema.columns WHERE table_name = 'yourtablename' ;
SELECT usename FROM pg_user ;
SELECT tablename FROM pg_tables WHERE schemaname = 'public' ; SELECT relname FROM pg_stat_user_tables ;