I'm not a PostgreSQL expert, but especially since python plays a role here,
the system language must be taken into account. If you are wanting no
conversion to be done on your "ASCII" data, then you will probably have to
go through special hoops.
On Tue, Jan 8, 2019, 5:19 PM Doug Easterbrook Had
Had a rethink of this. We had sql ascii databases with non ascii data in
it. When converting that data to utf8 and sticking into Postgres, all that
windows extended characters could not be used unless converted to utf8 before
hand.
It may be that your case depends 9n the character coding
Doug,
Hi. Is this a typo?
We’ve Postgres reject putting such stuff into the database using anything .
PostgreSQL allow *any text* into a column if the database has been set to
use SQL_ASCII as the encoding. This was the default encoding on Windows
machines, a long long time ago. All that set
https://www.cl.cam.ac.uk/~mgk25/ucs/quotes.html
Smart quotes are not ascii. They are Unicode, strictly speaking .
We’ve Postgres reject putting such stuff into the database using anything .
Sent from my iPad
> On Jan 8, 2019, at 9:23 AM, richard coleman
> wrote:
>
> Dave,
>
> Thanks f
Dave,
Thanks but this is my ~/Library/Preferences/org.pgadmin.pgadmin4.plist with the
Browser command filled in
(I have removed the content of the data tags)
http://www.apple.com/DTDs/PropertyList-1.0.dtd";>
Browser.Geometry
Browser.LastSaveLocation
On Tue, Jan 8, 2019 at 8:55 PM Nanina Tron wrote:
>
>
> Hi,
>
> yes thank you I will scan the table so at least I will see the 'bad'
> characters. We will see how many there are.
> Sorry, i forgot to append the data.
Thanks. Did that include the "bad" data? I can load it just fine into
a SQL_ASC
Hi
On Tue, Jan 8, 2019 at 7:32 PM richard coleman
wrote:
>
> Dave,
>
> I would imagine Nanina would be in a better position to provide you with
> problematic import/export data in the short term. I don't tend to
> import/export that often these days, preferring to use SQL statements for
> mos
On Tue, Jan 8, 2019 at 9:45 PM Patrick De Visschere
wrote:
> Can someone tell were this command is saved, because I have to reenter it
> from time to time.
>
~/Library/Preferences/org.pgadmin.pgadmin4.plist on macOS.
> On 8 Jan 2019, at 17:10, Steve Hawes wrote:
>
> Sheldon,
>
> The /usr/bin/
Can someone tell were this command is saved, because I have to reenter it from
time to time.
Regards,
P. De Visschere
> On 8 Jan 2019, at 17:10, Steve Hawes wrote:
>
> Sheldon,
>
> The /usr/bin/firefox %URL% is the placeholder text that is used as an example
> for the browser command. I hav
Sheldon,
The /usr/bin/firefox %URL% is the placeholder text that is used as an example
for the browser command. I have tried with Chrome as my default browser and
this works fine but I want to keep Safari as the default browser but use Chrome
only for pgAdmin.
Following the reply I got from Ri
Hi
On Tue, Jan 8, 2019 at 9:12 PM Strauch, Sheldon wrote:
> Interestingly enough, I use Chrome exclusively and my Browser Command is
> configured to: */usr/bin/firefox %URL%*
>
I think you'll find that's the placeholder hint text, not a value. I'll bet
you can't copy/paste it, and if you try to
Hi
On Tue, Jan 8, 2019 at 8:32 PM Steve Hawes wrote:
> Hi,
>
>
>
> Can anyone help me with changing the browser used by pgAdmin in MacOS
> Mojave.
>
>
>
> I have Google Chrome installed and can see that there is a box for
> entering the Browser Command in the pgAdmin configuration but I cannot w
Interestingly enough, I use Chrome exclusively and my Browser Command is
configured to: */usr/bin/firefox %URL%*
When selecting *New pgAdmin 4 Window...* the new window opens in Chrome.
Seeing as firefox is not even installed, I believe in the absence of a
working command pgAdmin 4 reverts to OSX's
Steve,
Well I have mine set to launch chromium with this command:
> chromium-browser %URL%
So I would imagine substituting the command to start chrome from the
command line would suffice.
Just a thought,
rik.
On Tue, Jan 8, 2019 at 10:02 AM Steve Hawes wrote:
> Hi,
>
>
>
> Can anyone help
Hi,
Can anyone help me with changing the browser used by pgAdmin in MacOS Mojave.
I have Google Chrome installed and can see that there is a box for entering the
Browser Command in the pgAdmin configuration but I cannot work out the syntax
for getting Chrome to launch instead of Safari. Any hel
Hi,
thanks for the multiple responses and interesting discussion I am struggeling
to keep up with all the new information.
I double checked, all settings I could find and the .csv files I want to
import. Everything is manually, or at creation of the db set to UTF8. I tried
to copy one of th
Nanina,
I am glad to hear that you are finding the discussion illuminating. You
might want to send a copy of your backup file (assuming it isn't sensitive
data) to Dave so that he can test pgAdmin4 against it. You might also want
to provide your OS and postgreSQL information as well. I've notice
Dave,
I would imagine Nanina would be in a better position to provide you with
problematic import/export data in the short term. I don't tend to
import/export that often these days, preferring to use SQL statements for
most things short of a full backup/restore (in my case I've found it to be
muc
Hi Rik
On Tue, Jan 8, 2019 at 6:53 PM richard coleman
wrote:
>
> Dave,
>
> Thanks for continuing this discussion, but I think you misunderstand the
> situation. I am storing valid non-UTF8 data in a SQL_ASCII encoded
> postgreSQL database (please re-read what I had previously written). This is
Dave,
Thanks for continuing this discussion, but I think you misunderstand the
situation. I am storing *valid* *non-UTF8* data in a SQL_ASCII encoded
postgreSQL database (please re-read what I had previously written). This is
why psql has *NO* problem dealing with it. This is also why Windows OD
Hi,
On Tue, Jan 8, 2019 at 3:59 PM Petr Fedorov
wrote:
> Hello,
>
> I'm using pgAdmin 4 version 3.6 on Centos 7, Postgresql 10.6 runs on the
> same machine. I use local connections.
>
> Almost everything works fine except for 'Statistics' tab when viewing
> pgAgent job log. It takes 60-90 second
Hello,
I'm using pgAdmin 4 version 3.6 on Centos 7, Postgresql 10.6 runs on the
same machine. I use local connections.
Almost everything works fine except for 'Statistics' tab when viewing
pgAgent job log. It takes 60-90 seconds to load, the whole pgAdmin4 is
frozen during the load, Firefox shows
22 matches
Mail list logo
