print list of column python code example
Example 1: python show all columns
pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', None)
Example 2: get column names as list
public static List<String> getColumnNames(){
List<String> columnList = new ArrayList<>();
try {
ResultSetMetaData rsMetaData = rs.getMetaData();
for (int colNum = 1; colNum < getColumnCount() ; colNum++) {
columnList.add(rsMetaData.getColumnLabel(colNum));
}
} catch (SQLException e) {
System.out.println("ERROR WHILE GETTING COLUMN NAMES "+ e.getMessage());
}
return columnList;
}