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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: psql show me the : and ask user input, when running one sql file
Дата
Msg-id CAKFQuwZskCXrq9RnOtvn7F-9ZeNBohKy5dsFfvWykCfC_gTCog@mail.gmail.com
обсуждение исходный текст
Ответ на psql show me the : and ask user input, when running one sql file  (arden liu <ardenbook@gmail.com>)
Ответы Re: psql show me the : and ask user input, when running one sql file
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Tim Clarke
Дата:
Сообщение: Re: psql show me the : and ask user input, when running one sql file
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: psql show me the : and ask user input, when running one sql file