steve.tout...@inspq.qc.ca writes:
> Using postgres 9.2, I created a FOREIGN TABLE on a csv file. It works.
> But I need to change the structure of the data and I created several sql
> select using union, like
> select from .foreign table... where...
> union
> select from .foreign table..
Alvaro Herrera writes:
> k...@rice.edu wrote:
>> Each SELECT opens your FOREIGN TABLE so you are opening it 10 times. This is
>> hardcoded by a #define in ./src/backend/storage/file/fd.c during the build so
>> you would need to recompile the software yourself to change it. Can you re-
>> write you
k...@rice.edu wrote:
> Each SELECT opens your FOREIGN TABLE so you are opening it 10 times. This is
> hardcoded by a #define in ./src/backend/storage/file/fd.c during the build so
> you would need to recompile the software yourself to change it. Can you re-
> write your query using a single SELECT
The csv has 34 columns and I need to create a crosstab (using 8 columns so
I can't use built in crosstab functions). That is why I need to make
several sql select.
I'm using foreign table so my client can update is csv file without having
to run the ETL to update a table in postgres.
Using tem
>
> Hi Steve,
>
> Each SELECT opens your FOREIGN TABLE so you are opening it 10 times.
> This is hardcoded by a #define in ./src/backend/storage/file/fd.c
> during the build so you would need to recompile the software yourself
> to change it. Can you re- write your query using a single SELECT or
On Tue, May 28, 2013 at 11:28:02AM -0400, steve.tout...@inspq.qc.ca wrote:
> Hi,
> Using postgres 9.2, I created a FOREIGN TABLE on a csv file. It works.
> But I need to change the structure of the data and I created several sql
> select using union, like
> select from .foreign table... where
Hi,
Using postgres 9.2, I created a FOREIGN TABLE on a csv file. It works.
But I need to change the structure of the data and I created several sql
select using union, like
select from .foreign table... where...
union
select from .foreign table... where...
union
...
It works for the firs
