[postgis-users] Error while importing data

Aditya aditya at grot.org
Fri Jun 3 19:48:09 PDT 2005


On Sat, Jun 04, 2005 at 02:36:57AM +0200, strk at refractions.net wrote:
> I downloaded your .sql file and it loads fine here:
[...]
> Postgis version is 1.0.1 installed from official package.
> 
> Another question: can you send description of your geometry_columns table ?

Let me know if you want more than this:

grot=> \d geometry_columns
            Table "public.geometry_columns"
      Column       |          Type          | Modifiers
-------------------+------------------------+-----------
 f_table_catalog   | character varying(256) | not null
 f_table_schema    | character varying(256) | not null
 f_table_name      | character varying(256) | not null
 f_geometry_column | character varying(256) | not null
 coord_dimension   | integer                | not null
 srid              | integer                | not null
 type              | character varying(30)  | not null
Indexes:
    "geometry_columns_pk" PRIMARY KEY, btree (f_table_catalog, f_table_schema,
f_table_name, f_geometry_column)

grot=> \d geometry_columns_pk
     Index "public.geometry_columns_pk"
      Column       |          Type
-------------------+------------------------
 f_table_catalog   | character varying(256)
 f_table_schema    | character varying(256)
 f_table_name      | character varying(256)
 f_geometry_column | character varying(256)
primary key, btree, for table "public.geometry_columns"

grot=> select * from geometry_columns ;
 f_table_catalog | f_table_schema | f_table_name | f_geometry_column |
coord_dimension | srid | type
-----------------+----------------+--------------+-------------------+-----------------+------+------
(0 rows)



More information about the postgis-users mailing list