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