| 1 |
<?php // $Id: postgis.inc,v 1.11 2008/09/25 21:51:33 vauxia Exp $ |
<?php // $Id: postgis.inc,v 1.12 2009/06/18 01:24:11 vauxia Exp $ |
| 2 |
|
|
| 3 |
/** |
/** |
| 4 |
* Postgresql + PostGIS backend for the geo field module |
* Postgresql + PostGIS backend for the geo field module |
| 5 |
* |
* |
| 6 |
* @author Mark Fredrickson |
* @author Mark Fredrickson |
| 7 |
* @version $Id: postgis.inc,v 1.11 2008/09/25 21:51:33 vauxia Exp $ |
* @version $Id: postgis.inc,v 1.12 2009/06/18 01:24:11 vauxia Exp $ |
| 8 |
* @package geo |
* @package geo |
| 9 |
*/ |
*/ |
| 10 |
|
|
| 119 |
a.attnotnull AS not_null, |
a.attnotnull AS not_null, |
| 120 |
d.adsrc AS default |
d.adsrc AS default |
| 121 |
FROM pg_class c |
FROM pg_class c |
| 122 |
LEFT JOIN pg_attribute a ON (a.attrelid = c.oid) LEFT OUTER JOIN pg_attrdef d ON (d.adrelid = c.oid AND d.adnum = a.attnum) |
LEFT JOIN pg_attribute a ON (a.attrelid = c.oid) |
| 123 |
|
LEFT OUTER JOIN pg_attrdef d ON (d.adrelid = c.oid AND d.adnum = a.attnum) |
| 124 |
WHERE c.relname = '%s' |
WHERE c.relname = '%s' |
| 125 |
AND a.attnum > 0 |
AND a.attnum > 0 |
| 126 |
AND NOT a.attisdropped |
AND NOT a.attisdropped |