[OSM-Devserver] Request to Install Hstore In osmosisci_pgsql06
Sven Geggus
lists at fuchsschwanzdomain.de
Mi Aug 25 17:08:12 CEST 2010
Brett Henderson <brett at bretth.com> wrote:
> Yep, that's fine. Thanks for the help.
OK, I just dropped your database and created a new one with postgis and
hstore-new:
osmosisci_pgsql06=# \d
Liste der Relationen
Schema | Name | Typ | Eigentümer
--------+------------------+---------+------------
public | geometry_columns | Tabelle | osmosisci
public | spatial_ref_sys | Tabelle | osmosisci
(2 Zeilen)
osmosisci_pgsql06=# create table foobar (tags hstore, way geometry);
CREATE TABLE
osmosisci_pgsql06=# \d foobar
Tabelle »public.foobar«
Spalte | Typ | Attribute
--------+----------+-----------
tags | hstore |
way | geometry |
osmosisci_pgsql06=# select DropGeometryTable('foobar');
dropgeometrytable
------------------------
public.foobar dropped.
(1 Zeile)
Regards
Sven
--
"Das Einzige, wovor wir Angst haben sollten, ist die Angst selbst"
(Franklin D. Roosevelt)
/me is giggls at ircnet, http://sven.gegg.us/ on the Web