Re: Testing required: pgAdmin 4 with new desktop runtime

I’cew got it installed on my mac. I’ll use it and see what I notice. Doug Easterbrook Arts Management Systems Ltd. mailto:d...@artsman.com http://www.artsman.com Phone (403) 650-1978 > On January 21, 2021, at 7:55 AM, Dave Page wrote: > > All, > > As you know, when run

Re: POSTGRES ISSUES

stock than that. [myPassword]. is a password of my choosing. read about the parameters using —help as the installer parameters. Doug Easterbrook Arts Management Systems Ltd. mailto:d...@artsman.com http://www.artsman.com Phone (403) 650-1978 > On September 22, 2019, at 4:21 AM, Andr

Re: How to deal with multiple accounts

that users and roles CAN cross multiple databases. if you really want segmentation between development and production, creating two different servers might be best. Doug Easterbrook Arts Management Systems Ltd. mailto:d...@artsman.com http://www.artsman.com Phone (403) 650-1978 > On May

Re: How to deal with multiple accounts

the way pgadmin seems to have been designed for eons. personally, I like that it saves my user id — and I supply the password.. thats how we use it. Doug Easterbrook Arts Management Systems Ltd. mailto:d...@artsman.com http://www.artsman.com Phone (403) 650-1978 > On May 18, 2019, at 3:19

Re: accessing a database out of network

check the pga_hba.conf file. and look at the server logs. if it says it is rejecting your ip address.. then you’ll know to reconfig the pg_hba.conf file and reload it within the server. Doug Easterbrook Arts Management Systems Ltd. mailto:d...@artsman.com http://www.artsman.com Phone (403) 650

Re: How to: copy records from one table to another?

unix). on windows, I think this is the one I’ve used http://gnuwin32.sourceforge.net/packages/sed.htm <http://gnuwin32.sourceforge.net/packages/sed.htm> there are others. it makes playing with these files somewhat scriptable. Doug Easterbrook Arts Management Systems Ltd. ma

Re: How to: copy records from one table to another?

not sure if its been mentioned. pg_dump -v -t (the specific table you want) which gives you the data plus the table create plus the sql edit sql if need be psql -d newdatabase < theFileAbove Doug Easterbrook Arts Management Systems Ltd. mailto:d...@artsman.com http://www.artsman.

Re: Default order on displaying data without order clause

eople want a natural order in a gui. Absolutely but you need to be explicit which one. Doug Easterbrook Arts Management Systems Ltd. mailto:d...@artsman.com http://www.artsman.com Phone (403) 650-1978 > On Mar 15, 2019, at 8:24 AM, Dave Caughey wrote: > > Yeah, but that's just

Re: Import/Export failure due to UTF-8 error in pgAdmin4 but not in pgAdmin3

correctly > translate the data into valid UTF8. It is my belief that it should handle > such valid postgreSQL data better than it currently does. At least as well > as it's predecessor pgAdmin3 did. > > Just my $0.02, > > rik. > > >> On Tue, Jan 8, 2019

Re: Import/Export failure due to UTF-8 error in pgAdmin4 but not in pgAdmin3

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

Re: pgadmin3 on macOS "Mojave"

. Its just nice that it works with postgres 10. Doug Easterbrook Arts Management Systems Ltd. mailto:d...@artsman.com http://www.artsman.com Phone (403) 650-1978 > On Nov 5, 2018, at 11:33 AM, Jack Royal-Gordon wrote: > > Hi Dave, > > Understood. I don’t think anyone expects y

Re: Where is the server log in pgAdmin v4

. so.. yes I vote for it back. Doug Easterbrook Arts Management Systems Ltd. mailto:d...@artsman.com http://www.artsman.com Phone (403) 650-1978 > On Aug 5, 2018, at 6:15 PM, David Blaymires > wrote: > > Hi, > > One thing that was incredibly valuable in pgAdmin v3 was b