Re: SQL pretty pritner?

2019-10-28 Thread DiasCosta
Hello, For some formatting I use PSPad.exe (https://www.pspad.com/) It has, at least, some of the features you are looking for. It is free and has the possibility to format SQL and other languages. Dias Costa On 28-10-2019 17:06, Reid Thompson wrote: On Sun, 2019-10-27 at 16:54 -0700,

Re: Importing from CSV, auto creating table?

2019-08-21 Thread DiasCosta
Hi Stan, I uploaded to the database (PostgreSQL 9.6), monthly and for several years, over 50 000 000 csv records using a version of pgtfutter that I compiled (with some changes if I remember correctly) and the tables were created in loading process from the column titles. Dias Costa On

Re: Recomended front ends?

2019-08-08 Thread DiasCosta
Hi, After many years of using Oracle Forms and Oracle Reports with Oracle DB, I have been using Lazarus and "Code Typhon" for many years now. Both work with Free Pascal Compiler and both are open source and free. Both have a very good IDE, the code produced is Pascal (very easily readable),

Re: Cloning schemas

2018-07-09 Thread DiasCosta
yourself. On Mon, Jul 9, 2018 at 2:56 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 07/09/2018 09:49 AM, Melvin Davidson wrote: On Mon, Jul 9, 2018 at 12:32 PM, DiasCosta mailto:diasco...@diascosta.org> <mailto:diasco...@d

Re: Cloning schemas

2018-07-09 Thread DiasCosta
help me, please? Thanks in advance Dias Costa On 07-07-2018 09:32, DiasCosta wrote: Hi Melvin, Thank you. Dias Costa On 04-07-2018 23:38, Melvin Davidson wrote: On Wed, Jul 4, 2018 at 2:48 PM, DiasCosta <mailto:diasco...@diascosta.org>> wrote: Hi Melvin, I'm new to

Re: Cloning schemas

2018-07-07 Thread DiasCosta
Hi Melvin, Thank you. Dias Costa On 04-07-2018 23:38, Melvin Davidson wrote: On Wed, Jul 4, 2018 at 2:48 PM, DiasCosta <mailto:diasco...@diascosta.org>> wrote: Hi Melvin, I'm new to clone_schema. Can I use it on PostgreSQL 9.6? TIA DCostaployment by invita

Re: Cloning schemas

2018-07-04 Thread DiasCosta
Hi Melvin, I'm new to clone_schema. Can I use it on PostgreSQL 9.6? TIA DCosta On 03-07-2018 14:34, Melvin Davidson wrote: ERROR: BŁĄD: you cannot add to column "TopoToVersion_ID" DETAIL: Column "TopoToVersion_ID" is an identity column defined as GENERATED ALWAYS. HINT: Use

Re: SQL Query never ending...

2018-06-22 Thread DiasCosta
and Fabrízio for their willingness to help me. They deserve a bottle of Porto wine each. Best regards Dias Costa On 21-06-2018 22:08, Tom Lane wrote: DiasCosta writes: This is the query plan for only 19684 rows. I think you're getting a bad query plan, mostly as a result of two factors

Re: SQL Query never ending...

2018-06-21 Thread DiasCosta
Hello David and Fabrízio, The names of the tables and indexes differ from the original script. Only the names. This is the query plan for only 19684 rows. I have another query running for around 3 rows, but it takes an eternity to finish. If it finishes in acceptable time I'll make it

SQL Query never ending...

2018-06-20 Thread DiasCosta
Hi all, can someone help me? I don't know if this is the correct list for this matter. If I'm wrong, please bear with me and point me in right direction. I have a large query which, largely after more than 24 hours running, doesn't come to an end; However I can see, using system tools, that