vendredi 21 février 2020

Insert automatically large amount of records in postgresSQL table

i need to populate my table randomly with large amount of record in PostgresSQL like 200k

CREATE TABLE qr_code.tbl_transaction (
    transaction_id varchar NOT NULL,
    importo numeric NOT NULL,
    alias varchar NOT NULL,
    order_id varchar NOT NULL,
    filiale varchar NOT NULL,
    descrizione varchar NOT NULL,
    data_creazione timestamp NOT NULL,
    terminale varchar NOT NULL,
    data_esecuzione timestamp NULL,
    chiave_movimento_prenotata varchar NULL,
    stato varchar NULL,
    codice_fiscale varchar(16) NULL,
    CONSTRAINT tbl_transaction_pk PRIMARY KEY (transaction_id)
);

How can i do this quickly?




Aucun commentaire:

Enregistrer un commentaire