[pgrouting-users] create geometry table with the result

[Talin Salway]

also, if you only need a temporary table, you can use:

CREATE TABLE [options, such as temporary] table_name> as SELECT * FROM . . . .

On Thu, Mar 15, 2012 at 5:22 PM, James David Smith
<james.david.smith at gmail.com> wrote:
> Hi,
>
> Unless I'm missing something, you just need to change the first line to
>
> SELECT * INTO new_table FROM shortest_path( ...... etc.
>
> James
>
> On 16 Mar 2012 00:14, "Pedro Costa" <pedrocostaarma at sapo.pt> wrote:
>>
>> Hello to all,
>>
>> Can anybody help me to solve this problem:
>>
>> I want to create a geometry table with the result of this query:
>>
>>
>> SELECT * FROM shortest_path
>> ('SELECT gid AS id,
>> source::int4 AS source,
>> target::int4 AS target,
>> lenght::float8 AS cost
>> FROM passeios',
>> 438,
>> 439,
>> false,
>> false)
>>
>> someone know how I do that?
>> thanks
>> _______________________________________________
>> Pgrouting-users mailing list
>> Pgrouting-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>