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 : ,
When I run any smaller SQL, psql does not ask any keyboard Input. I don't
know what causes this input
On Sun., Apr. 5, 2020, 12:46 p.m. Adrian Klaver,
wrote:
> On 4/5/20 5:50 AM, arden liu wrote:
> > I am using psql to run this sql
> > file(
> https://github.com/Arelle/Ar
aver,
wrote:
> On 4/5/20 9:46 AM, Adrian Klaver wrote:
> > 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)
>
> >&g
Does that RETURNING need any user input?
On Sun., Apr. 5, 2020, 1:10 p.m. Adrian Klaver,
wrote:
> On 4/5/20 9:46 AM, Adrian Klaver wrote:
> > On 4/5/20 5:50 AM, arden liu wrote:
>
> > 4) I don't see anything wrong the statements, so I am wondering if it is
> > a sh
Hi Adrian,
I also consider it's related to Shell . Because when I run it from Java , I
don't have this input request.
Let me check some configuration of bash and try again.
Thanks a lot.
Arden
On Sun., Apr. 5, 2020, 2:09 p.m. Adrian Klaver,
wrote:
> On 4/5/20 10:51 AM, ar
Hi Daniel,
"-P pager=off" works I think you found the root cause.
Thanks for your help.
Arden
On Sun, Apr 5, 2020 at 2:32 PM Daniel Verite
wrote:
> Adrian Klaver wrote:
>
> > On 4/5/20 9:46 AM, Adrian Klaver wrote:
> > > On 4/5/20 5:50 AM, arden liu
