public List <dynamic> GetColumns(Util.SqlHelper sqlHelper, string dataBaseName, string tableName)
{
return(sqlHelper.ExecuteDynamic(string.Format("select column_name as name,data_type as type,character_maximum_length length,is_nullable as isnullable from information_schema.columns where table_name='{0}'", tableName)));
}
public List <dynamic> GetTables(Util.SqlHelper sqlHelper, string dataBaseName)
{
return
(sqlHelper.ExecuteDynamic(
"select tablename as name from pg_tables where tablename not like 'pg_%' and tablename not like 'sql_%' order by tablename"));
}
