Postgres Pro
Downloads
Home   >   mailing lists

Re: psql show me the : and ask user input, when running one sql file - Mailing list pgsql-general

From David G. Johnston
Subject Re: psql show me the : and ask user input, when running one sql file
Date
Msg-id CAKFQuwZskCXrq9RnOtvn7F-9ZeNBohKy5dsFfvWykCfC_gTCog@mail.gmail.com
Whole thread Raw
In response to psql show me the : and ask user input, when running one sql file  (arden liu <ardenbook@gmail.com>)
Responses Re: psql show me the : and ask user input, when running one sql file
List pgsql-general
Tree view
On Sun, Apr 5, 2020 at 5:50 AM arden liu <ardenbook@gmail.com> 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?

If you can manually execute incremental portions of the file until the final statement introduces the problem I'll be happy to try and explain what may be wrong with that statement or portion of the file.

Removing stuff instead of just commenting it out is recommended.

David J.

pgsql-general by date:

Previous
From: Tim Clarke
Date:
Subject: Re: psql show me the : and ask user input, when running one sql file
Next
From: Rob Sargent
Date:
Subject: Re: psql show me the : and ask user input, when running one sql file