psql show me the : and ask user input, when running one sql file

From: arden liu <ardenbook(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: psql show me the : and ask user input, when running one sql file
Date: 2020-04-05 12:50:12
Message-ID: CAK0Kdkmw2buewJ1cW02XJM+D2mWz_vd+5k7xZ4ctPkjbFSdiwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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?
Thanks.
Arden

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Clarke 2020-04-05 13:46:10 Re: psql show me the : and ask user input, when running one sql file
Previous Message Olivier Gautherot 2020-04-05 08:59:02 Re: Using compression on TCP transfer