Hello,

I want to see all rows of my table with this sql query on pgadmin4 v1.4 on my 
PC with windows 7.

Select * from  public.fil

this table as 930000 rows, the table size is 79Mo

the ddl is
CREATE TABLE public.fil
(
    identifiant integer NOT NULL,
    numero integer NOT NULL,
    numeroregroupement integer,
    id_tube integer,
    statut character(3) COLLATE pg_catalog."default",
    numero_tete_cable smallint,
    attribute1 character varying(25) COLLATE pg_catalog."default",
    attribute2 character varying(25) COLLATE pg_catalog."default",
    attribute3 character varying(25) COLLATE pg_catalog."default",
    connexion_origine character varying(5) COLLATE pg_catalog."default",
    connexion_extremite character varying(5) COLLATE pg_catalog."default",
    CONSTRAINT id_fil PRIMARY KEY (identifiant)
        USING INDEX TABLESPACE idx_1,
    CONSTRAINT fk_id_tube FOREIGN KEY (id_tube)
        REFERENCES public.tube (identifiant) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE CASCADE
)

After a long time pgadmin4 crash without message or log

This sql query work fine with pgadmin3 1.22.1 on the same PC but this is very 
slow 52s


Regards
Francis




Reply via email to