Re: PostgreSQL - unrecognized win32 error code: 38

2019-10-28 Thread Michael Paquier
On Mon, Oct 28, 2019 at 09:51:07AM -0700, ZhenHua Cai wrote: > The following is the SQL statement of that function. > > DROP TABLE IF EXISTS "GenericReadList" ; > CREATE TEMP TABLE "GenericReadList"( > "ComputerProfileId" int NOT NULL, > "Trustee" uuid NOT NULL, > "AccessControlType" smallint NULL

Re: SQL pretty pritner?

2019-10-28 Thread Thiemo Kellner
https://www.sqlinform.com/ Quoting stan : I have a presentation later in the week, and i plan on printing out some files containing SQL commands. I have used some "pretty printers" in the past for things like Perl scripts. What I am thinking of s something that bolds keywords, handles page brea

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, Adria

Re: PostgreSQL - unrecognized win32 error code: 38

2019-10-28 Thread ZhenHua Cai
The following is the SQL statement of that function. DROP TABLE IF EXISTS "GenericReadList" ; CREATE TEMP TABLE "GenericReadList"( "ComputerProfileId" int NOT NULL, "Trustee" uuid NOT NULL, "AccessControlType" smallint NULL, "AceOrder" int NULL ); INSERT INTO "GenericReadList" SELECT t1."Compute

Re: SQL pretty pritner?

2019-10-28 Thread Reid Thompson
On Sun, 2019-10-27 at 16:54 -0700, Adrian Klaver wrote: > https://urldefense.proofpoint.com/v2/url?u=https-3A__sourceforge.net_projects_pgformatter_&d=DwICaQ&c=w8fEmIi-B5lsC0MnOiGTloUx5YmN70-3jVCmqqbXNxM&r=4r1gVE34nFB7YgioINuzq1cdGrlIBszDh26sKYP7ux8&m=9zYVbOR6UMXoTr5abTczqiDnMEYJ1mNU7uePMEtYLJ8&s=7

RE: SQL pretty pritner?

2019-10-28 Thread Kevin Brannen
>From: Adrian Klaver >On 10/27/19 3:21 PM, stan wrote: >> I have a presentation later in the week, and i plan on printing out >> some files containing SQL commands. I have used some "pretty printers" >> in the past for things like Perl scripts. What I am thinking of s >> something that bolds keywo

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-28 Thread Yessica Brinkmann
Thank you very much for the answer. Best regards, Yessica Brinkmann El lun., 28 oct. 2019 a las 8:03, Joe Conway () escribió: > On 10/27/19 8:01 PM, Yessica Brinkmann wrote: > > Thank you so much for the answers. > > By telling me this: "MemoryContextStrdup enables you to create a copy of > > a

Re: jsonb_set() strictness considered harmful to data

2019-10-28 Thread Mark Felder
On Mon, Oct 28, 2019, at 08:52, Andrew Dunstan wrote: > > For release 13+, I have given some more thought to what should be done. > I think the bar for altering the behaviour of a function should be > rather higher than we have in the present case, and the longer the > function has been sanctio

Re: SQL pretty pritner?

2019-10-28 Thread Basques, Bob (CI-StPaul)
All, VI has a lot of option ( that I haven’t tried) and I would bet that there are options for formatting and page breaks, etc. It’s a bit of a learning curve though. bobb > On Oct 28, 2019, at 8:44 AM, Rob Sargent wrote: > > Think Before You Click: This email originated outside our organ

Re: SQL pretty pritner?

2019-10-28 Thread Basques, Bob (CI-StPaul)
As far using VIM (vs EMACS): https://en.wikipedia.org/wiki/Editor_war :c) bobb On Oct 28, 2019, at 8:33 AM, Rob Sargent mailto:robjsarg...@gmail.com>> wrote: Think Before You Click: This email originated outside our organization. On Oct 28, 2019, at 7:00 AM, Basques, Bob (CI-StPaul) mai

Re: jsonb_set() strictness considered harmful to data

2019-10-28 Thread Andrew Dunstan
On 10/21/19 9:28 AM, Andrew Dunstan wrote: > On 10/21/19 2:07 AM, Tomas Vondra wrote: >> On Sun, Oct 20, 2019 at 06:51:05PM -0400, Andrew Dunstan wrote: I think the general premise of this thread is that the application developer does not realize that may be necessary, because it's a bit

Re: SQL pretty pritner?

2019-10-28 Thread Thomas Boussekey
Hello all, I use this github project in order to highlight SQL code on my slides: https://romannurik.github.io/SlidesCodeHighlighter/ It doesn't highlight 100% of Postgres SQL code, but it's a correct basis! Hope this helps, Thomas Le lun. 28 oct. 2019 à 14:37, Ron a écrit : > But does it ref

Re: SQL pretty pritner?

2019-10-28 Thread Rob Sargent
> On Oct 28, 2019, at 7:37 AM, Ron wrote: > > But does it reformat the text? > It’s an “indented text mode” so beeline respect current indentation. I don’t think it will take an stream out sql and add newlines at predictable places. Not at My desk to try. >> On 10/28/19 8:00 AM, Basques,

Re: SQL pretty pritner?

2019-10-28 Thread Ron
But does it reformat the text? On 10/28/19 8:00 AM, Basques, Bob (CI-StPaul) wrote: All, Take a look at the VI(m) editor. There is a Syntax mode for highlighting different file types, as well as tools for exporting the highlighted text to HTML. I have yet to find a file type that it doesn’t

Re: SQL pretty pritner?

2019-10-28 Thread Rob Sargent
> On Oct 28, 2019, at 7:00 AM, Basques, Bob (CI-StPaul) > wrote: > > All, > > Take a look at the VI(m) editor. There is a Syntax mode for highlighting > different file types, as well as tools for exporting the highlighted text to > HTML. I have yet to find a file type that it doesn’t al

Re: SQL pretty pritner?

2019-10-28 Thread Basques, Bob (CI-StPaul)
All, Take a look at the VI(m) editor. There is a Syntax mode for highlighting different file types, as well as tools for exporting the highlighted text to HTML. I have yet to find a file type that it doesn’t already handle. Works really slick. bobb > On Oct 27, 2019, at 5:21 PM, stan wro

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-28 Thread Joe Conway
On 10/27/19 8:01 PM, Yessica Brinkmann wrote: > Thank you so much for the answers. > By telling me this: "MemoryContextStrdup enables you to create a copy of > a string in an explicitly specified memory context." I better understood > the function of MemoryContextStrdup. > And thank you very much t