| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | arden liu <ardenbook(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: psql show me the : and ask user input, when running one sql file |
| Date: | 2020-04-05 14:24:23 |
| Message-ID: | CAKFQuwZskCXrq9RnOtvn7F-9ZeNBohKy5dsFfvWykCfC_gTCog@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Apr 5, 2020 at 5:50 AM arden liu <ardenbook(at)gmail(dot)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(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?
>
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2020-04-05 14:36:25 | Re: psql show me the : and ask user input, when running one sql file |
| Previous Message | Tim Clarke | 2020-04-05 13:46:10 | Re: psql show me the : and ask user input, when running one sql file |