postgresql-for-wordpress/tests/stubs/show-full-_1698679923.txt

{"mysql":"SHOW FULL COLUMNS FROM `wp_blogs`","postgresql":"    SELECT \n        a.attname AS \"Field\",\n        pg_catalog.format_type(a.atttypid, a.atttypmod) AS \"Type\",\n        (CASE \n            WHEN a.attnotnull THEN 'NO' \n            ELSE 'YES' \n        END) AS \"Null\",\n        (CASE \n            WHEN i.indisprimary THEN 'PRI'\n            WHEN i.indisunique THEN 'UNI'\n            ELSE '' \n        END) AS \"Key\",\n        pg_catalog.pg_get_expr(ad.adbin, ad.adrelid) AS \"Default\",\n        '' AS \"Extra\",\n        'select,insert,update,references' AS \"Privileges\",\n        d.description AS \"Comment\"\n    FROM \n        pg_catalog.pg_attribute a\n        LEFT JOIN pg_catalog.pg_description d ON (a.attrelid = d.objoid AND a.attnum = d.objsubid)\n        LEFT JOIN pg_catalog.pg_attrdef ad ON (a.attrelid = ad.adrelid AND a.attnum = ad.adnum)\n        LEFT JOIN pg_catalog.pg_index i ON (a.attrelid = i.indrelid AND a.attnum = ANY(i.indkey))\n    WHERE \n        a.attnum > 0 \n        AND NOT a.attisdropped\n        AND a.attrelid = (\n            SELECT c.oid\n            FROM pg_catalog.pg_class c\n            LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n            WHERE c.relname = 'wp_blogs'\n            AND n.nspname = 'public'\n        )\n    ORDER BY \n        a.attnum;"}