- Timestamp:
- 2011/04/16 23:47:58 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_11-dev/data/class/db/dbfactory/SC_DB_DBFactory_PGSQL.php
r20792 r20850 193 193 } 194 194 return $sql; 195 }196 197 /**198 * テーブルのカラム一覧を取得する.199 *200 * @deprecated SC_Query::listTableFields() を使用してください201 * @param string $table_name テーブル名202 * @return array テーブルのカラム一覧の配列203 */204 function sfGetColumnList($table_name) {205 $objQuery =& SC_Query_Ex::getSingletonInstance();206 $sql = " SELECT a.attname "207 . " FROM pg_class c, pg_attribute a "208 . " WHERE c.relname=? "209 . " AND c.oid=a.attrelid "210 . " AND a.attnum > 0 "211 . " AND not a.attname "212 . " LIKE '........pg.dropped.%........' "213 . "ORDER BY a.attnum";214 $arrColList = $objQuery->getAll($sql, array($table_name));215 $arrColList = SC_Utils_Ex::sfswaparray($arrColList);216 return $arrColList['attname'];217 195 } 218 196
Note: See TracChangeset
for help on using the changeset viewer.