On 4/5/20 5:50 AM, arden liu wrote: > I am using psql to run this sql > file(https://github.com/Arelle/Arelle/blob/master/arelle/plugin/xbrlDB/sql/public/xbrlPublicPostgresDB.ddl) > here is my command: > /usr/bin/psql postgresql://db_user:dbpassword@localhost:5432/my_db -f > /tmp/xbrlPublicPostgresDB.ddl > I do not know why it show me the : , which is asking me to input something. > Can someone help me?
Well I ran the file(basically a modified dump file) and what I found is it:
1) Hung on:
INSERT INTO industry (industry_id, industry_classification, industry_code, industry_description, depth, parent_id) VALUES ... RETURNING industry_id;