Re: conf of postgres.cof

2021-06-12 Thread Patrick Headley
which client you are talking about. That may be helpful in troubleshooting the issue. */Patrick Headley/* Linx Consulting, Inc. (303) 916-5522 phead...@linxco-inc.com www.linxco-inc.com On 6/12/21 12:31 AM, Sachin Kumar wrote: Hi Experts, I am using Postgres 12 and 13 in two f my server and ge

Re: Import 2GB .sql file

2020-01-02 Thread Patrick Headley
psql instructions are at: https://www.postgresql.org/docs/current/app-psql.html */Patrick Headley/* Linx Consulting, Inc. (303) 916-5522 phead...@linxco-inc.com www.linxco-inc.com On 1/2/20 12:03 PM, Travis Harris wrote: I have a 2GB sql file that I need to import. It is a database backup

Re: Import 2GB .sql file

2020-01-02 Thread Patrick Headley
Sorry, I missed some of the text from this email when I initially replied. You should be able to find instructions for restoring an sql file at https://www.postgresql.org/. */Patrick Headley/* Linx Consulting, Inc. (303) 916-5522 phead...@linxco-inc.com www.linxco-inc.com On 1/2/20 12:03 PM

Re: Import 2GB .sql file

2020-01-02 Thread Patrick Headley
Is that a 2GB backup or data file? The methods to import the data will be different depending on what you are starting with. */Patrick Headley/* Linx Consulting, Inc. (303) 916-5522 phead...@linxco-inc.com www.linxco-inc.com On 1/2/20 4:20 PM, Christophe Pettus wrote: On Jan 2, 2020, at 11

Re: joining tables

2019-09-03 Thread Patrick Headley
IN (SELECT [contenation of] key_column(s) FROM table1); */Patrick Headley/* Linx Consulting, Inc. (303) 916-5522 phead...@linxco-inc.com www.linxco-inc.com On 9/3/19 5:01 AM, TedJones wrote: Hi Patrick Thanks for your response. The tables that I gave were just an example and there is no rele

Re: joining tables

2019-09-02 Thread Patrick Headley
nless the same field could have more than one value. */Patrick Headley/* Linx Consulting, Inc. (303) 916-5522 phead...@linxco-inc.com www.linxco-inc.com On 9/2/19 11:24 AM, TedJones wrote: I'm having problems joining 3 tables to provide a 4th table in the correct format. I believe I need a

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

2019-03-22 Thread Patrick Headley
You could also use MS Access if you already have it. It can connect to multiple databases and allow you to run an INSERT query that can pull from one DB and save to the other. */Patrick Headley/* Linx Consulting, Inc. (303) 916-5522 phead...@linxco-inc.com www.linxco-inc.com On 3/22/19 8:34 AM

Please make these modifications to the Open dialog for the Query Tool

2019-02-08 Thread Patrick Headley
, if an option already exists. Otherwise, please add the option or maybe just use the font sizes specified in the query tool. -- */Patrick Headley/* Linx Consulting, Inc. (303) 916-5522 phead...@linxco-inc.com www.linxco-inc.com

Re: Query Tool Initialization Error

2018-05-19 Thread Patrick Headley
Apparently life isn't too short to wait for Windows product updates and troubleshoot bugs in MS products. On 05/19/2018 07:14 AM, Chris @ Home wrote: I decided to switch to SQL Server. Life is too short to debug open source database tools! Sent from iPhone On 17 May 2018, at 09:13, Murtuza

F5 key not consistent

2018-04-14 Thread Patrick Headley
would be nice if pressing F5 in the object browser would refresh the current object level. pgAdmin4 v3.0 Firefox Microsoft Windows 10 -- */Patrick Headley/* Linx Consulting, Inc. (303) 916-5522 phead...@linxco-inc.com www.linxco-inc.com

Re: How to copy the graphical display of a plan?

2018-03-25 Thread Patrick Headley
I didn't verify what the original poster said but I would like to add that it should be possible to save the query plan to a GIF. */Patrick Headley/* Linx Consulting, Inc. (303) 916-5522 phead...@linxco-inc.com www.linxco-inc.com On 03/15/2018 01:42 AM, Holger Jakobs wrote: Dear fr