A
A
Analka2021-09-03 09:47:48
PostgreSQL
Analka, 2021-09-03 09:47:48

Why is there an error when importing values ​​into a PostgreSql table?

there is a Geo table

- network(cidr not null), geoname_id(bigint)

on import gives

2:1: conversion failed: "1.0.0.0/24" to cidr (network)
3:1: conversion failed: "1.0.1.0/24" to cidr (network)
4:36: actual: end of file, expected: value


csv file

51.158.182.0/24,3017382,3017382,,0,0
51.158.183.0/27,3017382,3017382,,0,0

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question