Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis, amqp, s3 in the future?

2017-05-07 Thread Steve Atkins
> On May 7, 2017, at 9:16 AM, Adam Brusselback > wrote: > > there's also pg_agent which is a cron-like extension, usually bundled with > pg_admin but also available standalone > > https://www.pgadmin.org/docs4/dev/pgagent.html > > > -- > john r pierce, recycling bits in santa cruz > > In

Re: [GENERAL]

2017-05-07 Thread Igor Korot
David, On Sun, May 7, 2017 at 8:57 AM, David Rowley wrote: > On 8 May 2017 at 00:42, Igor Korot wrote: >> Basically what I'd like to see is the definition of each column and >> whether this column is >> part of primary/foreign key or not. > > information_schema.table_constraints is of no use to

Re: [GENERAL] Sample in documentation

2017-05-07 Thread Igor Korot
Tom et al, On Sun, May 7, 2017 at 1:09 PM, Tom Lane wrote: > Igor Korot writes: >> On Sat, May 6, 2017 at 8:22 PM, Tom Lane wrote: >>> I do not see any arrays named "length", nor even any arrays of size 2, >>> on that page, so I'm pretty confused what you're talking about. Please >>> be more s

Re: [GENERAL] Sample in documentation

2017-05-07 Thread Tom Lane
Igor Korot writes: > On Sat, May 6, 2017 at 8:22 PM, Tom Lane wrote: >> I do not see any arrays named "length", nor even any arrays of size 2, >> on that page, so I'm pretty confused what you're talking about. Please >> be more specific. > I based my code on this: > http://stackoverflow.com/que

Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis, amqp, s3 in the future?

2017-05-07 Thread Adam Brusselback
> > there's also pg_agent which is a cron-like extension, usually bundled with > pg_admin but also available standalone > > https://www.pgadmin.org/docs4/dev/pgagent.html > > > -- > john r pierce, recycling bits in santa cruz > In addition to that, there is also jpgAgent: https://github.com/GoSim

Re: [GENERAL]

2017-05-07 Thread Tom Lane
David Rowley writes: > On 8 May 2017 at 00:42, Igor Korot wrote: >> Basically what I'd like to see is the definition of each column and >> whether this column is part of primary/foreign key or not. > information_schema.table_constraints is of no use to you then. There > are no details about whic

Re: [GENERAL]

2017-05-07 Thread David Rowley
On 8 May 2017 at 00:42, Igor Korot wrote: > Basically what I'd like to see is the definition of each column and > whether this column is > part of primary/foreign key or not. information_schema.table_constraints is of no use to you then. There are no details about which column(s) the constraint a

Re: [GENERAL]

2017-05-07 Thread Igor Korot
David, On Sun, May 7, 2017 at 7:57 AM, David Rowley wrote: > On 7 May 2017 at 16:43, Igor Korot wrote: >> I'm trying to retrieve an information about the table. Query is below: >> >> SELECT cols.column_name, cols.data_type, >> cols.character_maximum_length, cols.character_octet_length, >> cols.n

Re: [GENERAL]

2017-05-07 Thread David Rowley
On 7 May 2017 at 16:43, Igor Korot wrote: > I'm trying to retrieve an information about the table. Query is below: > > SELECT cols.column_name, cols.data_type, > cols.character_maximum_length, cols.character_octet_length, > cols.numeric_precision, cols.numeric_precision_radix, > cols.numeric_scale

Re: [GENERAL]

2017-05-07 Thread Igor Korot
Andreas, On Sun, May 7, 2017 at 6:02 AM, Andreas Kretschmer wrote: > Igor Korot wrote: > >> Hi, >> I'm trying to retrieve an information about the table. Query is below: >> >> SELECT cols.column_name, cols.data_type, >> cols.character_maximum_length, cols.character_octet_length, >> cols.numeric_

Re: [GENERAL]

2017-05-07 Thread Andreas Kretschmer
Igor Korot wrote: > Hi, > I'm trying to retrieve an information about the table. Query is below: > > SELECT cols.column_name, cols.data_type, > cols.character_maximum_length, cols.character_octet_length, > cols.numeric_precision, cols.numeric_precision_radix, > cols.numeric_scale, cols,column_de