2022-03-26 6:35 GMT-03:00, rob...@redo2oo.ch :
> Hi Friends
>
> I would like to generate the path of a CSV file to which I output a query.
>
> This is what I try:
>
> CREATEORREPLACEPROCEDUREexport_cvs(
> home_dir varchar
> )
> AS
> $BODY$
> DECLARE
> OUTFILE varchar;
> BEGIN
> OUTFILE = (home_dir
I simply did the following:
Get intersections through self-joining lines table where a.fid not equal to
b.fid
Put buffered intersections with geometry from lines table together to view.
Some odd things were observed.
Buffer turned up, but supposed lines did not show.
Why does this happen?
Hi Friends
I would like to generate the path of a CSV file to which I output a query.
This is what I try:
CREATEORREPLACEPROCEDUREexport_cvs(
home_dir varchar
)
AS
$BODY$
DECLARE
OUTFILE varchar;
BEGIN
OUTFILE = (home_dir || '/tmp/company.csv');
copy(
select'company_'||id as"External ID",
namea
