getTablesRawFromDb function
Future<List<Map<String, Map<String, dynamic> > > >
getTablesRawFromDb(
- PostgreSQLConnection connection,
- String table_schema
go to the db and return the list of tables with column details
Implementation
Future<List<Map<String, Map<String, dynamic>>>> getTablesRawFromDb(
PostgreSQLConnection connection,
String table_schema,
) async {
try {
await connection.open();
var dbResult = await connection.mappedResultsQuery(
"""
select table_name, udt_name, column_name, is_nullable, is_identity, *
from "information_schema"."columns"
where table_schema = @table_schema
order by table_name, is_identity desc, is_nullable, udt_name, column_name
""",
substitutionValues: {"table_schema": table_schema},
);
return dbResult;
} finally {
connection.close();
}
}