laravel_postgresschema2json.php

<?php

use Illuminate\Support\Facades\DB;

$query = "SELECT tables.table_name, columns.column_name, columns.data_type, columns.udt_name FROM information_schema.tables AS tables JOIN information_schema.columns AS columns ON tables.table_name = columns.table_name WHERE tables.table_type = 'BASE TABLE' AND tables.table_schema NOT IN ('pg_catalog', 'information_schema')";

$data = json_decode(collect(DB::select($query)));