| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * Returns list of tables in a database |
|---|
| | | * |
|---|
| | | * @return array List of all tables of the current database |
|---|
| | | */ |
|---|
| | | public function list_tables() |
|---|
| | | { |
|---|
| | | // get tables if not cached |
|---|
| | | if ($this->tables === null) { |
|---|
| | | $q = $this->query("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES" |
|---|
| | | . " WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA NOT IN ('pg_catalog', 'information_schema')" |
|---|
| | | . " ORDER BY TABLE_NAME"); |
|---|
| | | |
|---|
| | | $this->tables = $q ? $q->fetchAll(PDO::FETCH_COLUMN, 0) : array(); |
|---|
| | | } |
|---|
| | | |
|---|
| | | return $this->tables; |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * Returns PDO DSN string from DSN array |
|---|
| | | * |
|---|
| | | * @param array $dsn DSN parameters |
|---|
