Re: Inserting default values into execute_values

2020-04-01 Thread Adrian Klaver
On 4/1/20 2:04 PM, Adrian Klaver wrote: On 4/1/20 1:31 PM, Stephen Lagree wrote: Thanks Daniele and Adrian, your answers were really helpful! Daniele, you are right, it is a waste sending long strings when I am just trying to generate entries in the sequence. I do want to do it in one shot so

Re: Inserting default values into execute_values

2020-04-01 Thread Adrian Klaver
On 4/1/20 1:31 PM, Stephen Lagree wrote: Thanks Daniele and Adrian, your answers were really helpful! Daniele, you are right, it is a waste sending long strings when I am just trying to generate entries in the sequence. I do want to do it in one shot so your generate_series suggestion should b

Re: Inserting default values into execute_values

2020-04-01 Thread Stephen Lagree
Thanks Daniele and Adrian, your answers were really helpful! Daniele, you are right, it is a waste sending long strings when I am just trying to generate entries in the sequence. I do want to do it in one shot so your generate_series suggestion should be great insert into testins (id) select n

Re: Inserting default values into execute_values

2020-04-01 Thread Adrian Klaver
On 3/31/20 7:16 PM, Daniele Varrazzo wrote: On 3/31/20 3:27 PM, Stephen Lagree wrote: Hello, I am trying to insert into a table to generate sequential ids. Is there a way to do this repeatedly using execute_values if there is only one column and it is auto incremented? The point of execute_v

Re: Inserting default values into execute_values

2020-03-31 Thread Daniele Varrazzo
> > On 3/31/20 3:27 PM, Stephen Lagree wrote: > >> Hello, > >> > >> I am trying to insert into a table to generate sequential ids. Is > >> there a way to do this repeatedly using execute_values if there is > >> only one column and it is auto incremented? The point of execute_values is to convert

Re: Inserting default values into execute_values

2020-03-31 Thread Adrian Klaver
On 3/31/20 3:57 PM, Adrian Klaver wrote: On 3/31/20 3:27 PM, Stephen Lagree wrote: Hello, I am trying to insert into a table to generate sequential ids.  Is there a way to do this repeatedly using execute_values if there is only one column and it is auto incremented? It seems the execute_val

Re: Inserting default values into execute_values

2020-03-31 Thread Adrian Klaver
On 3/31/20 3:27 PM, Stephen Lagree wrote: Hello, I am trying to insert into a table to generate sequential ids.  Is there a way to do this repeatedly using execute_values if there is only one column and it is auto incremented? It seems the execute_values requires at least one non-default valu