Re: query tool csv/txt output file extension choice and encoding

2021-02-05 Thread Alain Dupeyron
nces" | "CVS/TXT Output" and choose your preferred delimiter (e.g., >>> Tab, "|", etc.), and thereafter that's what pgAdmin will always use when >>> you do an "export to file", but will give it an ".txt" extension so Excel &g

query tool csv/txt output file extension choice and encoding

2021-02-05 Thread Alain Dupeyron
Hi, I'm using frequently the download file function in the query tool. In previous version of PgAdmin4, I select field separator ";"  and file was always generated with extension .csv and can be opened directly by Excel in one click with correct columns ! Now I have always .txt extension (since

Re: display bigint precision problem in pgAdmin4 ?

2020-11-09 Thread Alain Dupeyron
> > I can not reproduce this issue at my end with pgAdmin v4.27. > Please provide OS, Browser and PG details. > > Thanks, > Khushboo > > On Fri, Nov 6, 2020 at 3:19 PM Alain Dupeyron wrote: > >> Hello, >> >> In PgAdmin 4.27 bigint values are not displaye

Re: display bigint precision problem in pgAdmin4 ?

2020-11-09 Thread Alain Dupeyron
uce this issue at my end with pgAdmin v4.27. Please provide OS, Browser and PG details. Thanks,Khushboo On Fri, Nov 6, 2020 at 3:19 PM Alain Dupeyron wrote: Hello, In PgAdmin 4.27 bigint values are not displayed correctly, The 2-3 last finest digits are to 000example here 6000 insteaf

display bigint precision problem in pgAdmin4 ?

2020-11-06 Thread Alain Dupeyron
Hello, In PgAdmin 4.27 bigint values are not displayed correctly, The 2-3 last finest digits are to 000example here 6000 insteaf of 6033 ?? select '2807160139143706033', 2807160139143706033, x'26f50946094bf5b1'::bigint, x'26f50946094bf5b1'::bit(64) '?column?'    '?column?'    'int8'    'bit'

PGAdmin 4: missing preferences setting to copy result headers name

2019-12-18 Thread Alain Dupeyron
Hi, In the sql query editor, there is a button to copy "result with headers" but i have to set this option on each sql tab opened and after each PGAdmin launch...It would be nice to add this setting in main preferences (as in PGAdmin 3) I'm not sure if it's the right place to ask enhancement for

PGAdmin 4: session detail case long SQL

2019-12-16 Thread Alain Dupeyron
Hi, In PG Admin 4, I use the dashboard, server activity to explore sessions on PG v12.1. In the Details panel of the session, I can see the start of the SQL, but when it's a long text query on multiple lines, How can I access the entire SQL command ? In PGAdmin 3 (on oldest PG v9.4), in tool

PGAdmin 4 session detail LONG SQL case

2019-12-05 Thread Alain Dupeyron
Hi, In PG Admin 4, I use the dashboard, server activity to explore sessions on PG v12.1. In the Details panel of the session, I can see the start of the SQL, but when it's a long text query on multiple lines, How can I access the entire SQL command ? In PGAdmin 3 (on oldest PG v9.4), in tool serv