to answer to Adrian
1) i am using the old version to dump (i will try with the latest)
2) no the postgis version is different. pg9.2.4-> postgis-2.0.3 and
pg9.3.5-> postgis-2.1.3
3) the schema is public
\d+ al_shared_place
Table
"public.al_shared_place"
Column | Type | Modifiers
| Storage | Stats target | Description
------------+-----------------------+---------------------------------------------------------------+----------+--------------+-------------
id | integer | not null default
nextval(('al_landmark_seq'::text)::regclass) | plain | |
x | character varying(15) |
| extended | |
y | character varying(15) |
| extended | |
name | character varying(50) |
| extended | |
placetype | integer |
| plain | |
point_geom | geometry |
| main | |
Indexes:
"al_shared_place_pkey" PRIMARY KEY, btree (id)
"al_sharedplace_geom_idx" gist (point_geom)
Check constraints:
"$1" CHECK (srid(point_geom) = 4326)
"$2" CHECK (geometrytype(point_geom) = 'POINT'::text OR point_geom IS
NULL)
Has OIDs: no
--
View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-not-dumping-all-tables-tp5827736p5827747.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
