Yes, thanks - that's nicer - I am now using:
insert into t_array select array[data_comp]::mytype[] from t_composite;
On Wed, Oct 25, 2017 at 5:25 PM, Tom Lane wrote:
> "David G. Johnston" writes:
> > On Wed, Oct 25, 2017 at 2:16 PM, Celia McInnis
> >> Go
Got it, finally...
insert into t_array select array[row((data_comp).*)::mytype[] from
t_composite;
I'm not sure why I need (data_comp).* rather than some of the other things
that I tried and failed with...
On Wed, Oct 25, 2017 at 3:47 PM, Tom Lane wrote:
> Celia McInnis writes:
>
ues?
I am running postgresql 9.6.2.
On Wed, Oct 25, 2017 at 3:47 PM, Tom Lane wrote:
> Celia McInnis writes:
> > My first question is: HOW do I populate this table, at first with arrays
> > containing one element from the t_composite table?
> > I have tried various things
I have a composite type like this, for example:
create type mytype(a text, b text, c text);
and a table
create table t_cols(a text,b text,c text);
containing some data. I have a table with my composite type:
create table t_composite(data_comp mytype);
and loaded data into it like so:
insert
2:05 PM, Celia McInnis wrote:
>
>> Is it possible for users to use their conda environment for plpython,
>> complete with the modules that they have loaded in that environment? If so,
>> what do I do?
>>
>> I am running postgres 9.6.2 and would like to use a
Is it possible for users to use their conda environment for plpython,
complete with the modules that they have loaded in that environment? If so,
what do I do?
I am running postgres 9.6.2 and would like to use a conda environment for
python 3.6 which contrains a fair number of modules that I want
Is there some way (apart from pre-processing my (huge) input files) to get the data correctly into postgres?
Thanks for your help,
Celia McInnis
