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

> 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

Re: [GENERAL]

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

Re: [GENERAL] Sample in documentation

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

Re: [GENERAL] Sample in documentation

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

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

> > 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:

Re: [GENERAL]

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

Re: [GENERAL]

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

Re: [GENERAL]

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

Re: [GENERAL]

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,

Re: [GENERAL]

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

Re: [GENERAL]

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

Re: [GENERAL] Where is the error?

## Igor Korot (ikoro...@gmail.com): > Another question - do I have to do "DECLARE CURSOR..." or I can just write > a normal SELECT query? > For this I followed and example on the libpg page... Yes. In fact, "libpq Example Program 3" on