Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- COPY obra(id,titulo)
- from 'C:\tmp\obra.csv' DELIMITER ',' CSV HEADER;
- COPY cliente(id,nombre,fecha_nto)
- from 'C:\tmp\cliente.csv' DELIMITER ',' CSV HEADER;
- COPY encargado(codigo,nombre)
- from 'C:\tmp\encargado.csv' DELIMITER ',' CSV HEADER;
- COPY director(id,nombre)
- from 'C:\tmp\director.csv' DELIMITER ',' CSV HEADER;
- COPY tarifa(id,valor,fecha_inicial,fecha_final)
- from 'C:\tmp\tarifa.csv' DELIMITER ',' CSV HEADER;
- COPY papel(codigo,nombre)
- from 'C:\tmp\papel.csv' DELIMITER ',' CSV HEADER;
- COPY actor(id,nombre,fecha_nto)
- from 'C:\tmp\actor.csv' DELIMITER ',' CSV HEADER;
- COPY teatro(id,nombre,direccion,codigo_encargado)
- from 'C:\tmp\teatro.csv' DELIMITER ',' CSV HEADER;
- COPY telefono_actor(id_actor,telefono)
- from 'C:\tmp\telefono_actor.csv' DELIMITER ',' CSV HEADER;
- COPY cliente_tarifa(id_tarifa,id_cliente,fecha_venta)
- from 'C:\tmp\cliente_tarifa.csv' DELIMITER ',' CSV HEADER;
- COPY obra_director(id_obra,id_director)
- from 'C:\tmp\obra_director.csv' DELIMITER ',' CSV HEADER;
- COPY telefono_director(id_director,telefono)
- from 'C:\tmp\telefono_director.csv' DELIMITER ',' CSV HEADER;
- COPY obra_actor(id_obra,id_actor,codigo_papel)
- from 'C:\tmp\obra_actor.csv' DELIMITER ',' CSV HEADER;
- COPY boleta(id,id_cliente,id_teatro,id_obra,fecha,hora_inicio,hora_fin)
- from 'C:\tmp\boleta.csv' DELIMITER ',' CSV HEADER;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement