[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