1

For a project I started to work with pgAdmin and QGIS, so I'm quite new in these things and I have a problem with the connection of the database to the QGIS.

I can connect myself to the database and can see the SCHEMAS "geo" and "public" and also some of the tables .. but only some of them, the one I want to connect myself to, doesn't pop up and I don't know why.. I created it like this:

-- Table: geo.casa

-- DROP TABLE geo.casa;

CREATE TABLE geo.casa
(
  id_casa serial NOT NULL,
  id_comunidad integer,
  geom geo.geometry(Point,4326),
  CONSTRAINT casa_pk PRIMARY KEY (id_casa),
  CONSTRAINT casa_comunidad_fk FOREIGN KEY (id_comunidad)
      REFERENCES geo.comunidad (id_comunidad) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE geo.casaa
  OWNER TO postgres;

I'm not sure what kind of information you need, so just tell me if you need anything else!

closed as off-topic by Vince, PolyGeo Dec 6 '16 at 3:35

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

If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    What you're really looking for is a tutorial on database security models, using PostgreSQL as the primary example. Setting ownership to the postgres user is more likely to be in the Don't list than the Do. – Vince Dec 6 '16 at 2:49