Re: conf of postgres.cof

2021-06-12 Thread Patrick Headley
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 getting

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
(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 relevance in the friend/yes or names/contact

Re: joining tables

2019-09-02 Thread Patrick Headley
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 FULL OUTER JOIN but does

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

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
. It 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 friends