Revision 28968 branches/v2_0_0_prep/libraries/libFMap_daldb/src/org/gvsig/fmap/dal/store/postgresql/PostgreSQLServerExplorer.java
| PostgreSQLServerExplorer.java | ||
|---|---|---|
| 33 | 33 |
import java.sql.Connection; |
| 34 | 34 |
import java.sql.SQLException; |
| 35 | 35 |
import java.sql.Statement; |
| 36 |
import java.util.ArrayList; |
|
| 37 |
import java.util.List; |
|
| 36 | 38 |
|
| 37 | 39 |
import org.gvsig.fmap.dal.DataStoreParameters; |
| 38 | 40 |
import org.gvsig.fmap.dal.NewDataStoreParameters; |
| ... | ... | |
| 218 | 220 |
} |
| 219 | 221 |
|
| 220 | 222 |
|
| 221 |
protected String getSQLForList(int mode, boolean showInformationDBTables) {
|
|
| 223 |
protected List getSQLForList(int mode, boolean showInformationDBTables) {
|
|
| 224 |
List list = new ArrayList(1); |
|
| 222 | 225 |
StringBuffer sqlBuf = new StringBuffer(); |
| 223 | 226 |
sqlBuf |
| 224 | 227 |
.append("SELECT null as TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, false as ISVIEW ");
|
| ... | ... | |
| 231 | 234 |
sqlBuf.append(" xxWHERExx ");
|
| 232 | 235 |
|
| 233 | 236 |
if (showInformationDBTables) {
|
| 234 |
return sqlBuf.toString().replaceAll("xxWHERExx", "");
|
|
| 237 |
list.add(sqlBuf.toString().replaceAll("xxWHERExx", ""));
|
|
| 235 | 238 |
} else {
|
| 236 |
return sqlBuf |
|
| 239 |
list |
|
| 240 |
.add(sqlBuf |
|
| 237 | 241 |
.toString() |
| 238 | 242 |
.replaceAll("xxWHERExx",
|
| 239 |
"WHERE TABLE_SCHEMA NOT IN ('information_schema','pg_catalog')");
|
|
| 243 |
"WHERE TABLE_SCHEMA NOT IN ('information_schema','pg_catalog')"));
|
|
| 240 | 244 |
|
| 241 | 245 |
} |
| 246 |
return list; |
|
| 242 | 247 |
|
| 243 | 248 |
|
| 244 | 249 |
} |
Also available in: Unified diff