1

Does anyone know what I may be doing wrong?

Foolish question from a newbie perhaps but as I reckon it may be the code for table "B" that I created, how do I edit the code in pgAdmin3?

The key aim of this is to migrate data from one table in MapInfo into an existing table with a completely different table structure in QGIS.

code for current table below:

-- Table: A."B"

-- DROP TABLE A."B";

CREATE TABLE A."B"
(
  "UID" integer NOT NULL,
  roadname character varying(100),
  CONSTRAINT tmp_ga2_pk PRIMARY KEY ("UID")
)
WITH (
  OIDS=FALSE
);
ALTER TABLE A."B"
  OWNER TO postgres;

closed as off-topic by JGH, Evil Genius, BERA, whyzar, Vince Oct 17 '18 at 12:51

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions relating to general IT or with no clear GIS component, are off-topic here but can be researched/asked at Stack Overflow (software development), Super User (computing hardware and software), Database Administrators (relational databases) and other SE sites" – JGH, Evil Genius, BERA, whyzar, Vince
If this question can be reworded to fit the rules in the help center, please edit the question.

0

when you drop table B if there are any objects depending on it, by default it won't be dropped unlees you mention CASCADE

DROP TABLE IF EXISTS B CASCADE;

maybe this is where it blocks

Not the answer you're looking for? Browse other questions tagged or ask your own question.