Hi,
I have no problem to add a column to a shapefile with:
ogrinfo myfile.shp -sql "ALTER TABLE myfile ADD fieldX integer"
But if I use, the second column is not added to the file.
ogrinfo myfile.shp -sql "ALTER TABLE myfile ADD fieldX integer(3), fieldY
integer(3)"
The shell gives me only
INFO:
On 2016-05-01 5:20 AM, aborruso wrote:
Hi,
I have no problem to add a column to a shapefile with:
ogrinfo myfile.shp -sql "ALTER TABLE myfile ADD fieldX integer"
But if I use, the second column is not added to the file.
ogrinfo myfile.shp -sql "ALTER TABLE myfile ADD fieldX integer(3), fieldY
i
Hi Jeff,
thank you.
jmckenna wrote
> I think you have to use 2 ogrinfo statements.
I know it, it works with 2 statements. Do you know why I cannot use my kind
of SQL command with all in one statement?
And what do you think about to add some note in the documentation, about the
origin of the imp
On Sun, May 1, 2016 at 5:30 AM, aborruso wrote:
>
>
> jmckenna wrote
> > I think you have to use 2 ogrinfo statements.
As far as I'm aware -- please correct me if I'm wrong --
ogrinfo only lists information about a file and doesn't
alter it.
"ogrinfo -sql" may well be executing the alter table
s
Hi Christine,
thank you.
Christine Waigl wrote
>
> As far as I'm aware -- please correct me if I'm wrong --
> ogrinfo only lists information about a file and doesn't
> alter it.
As I written in my message I'm able to use ogrinfo to alterate my source
file, but if I want to add 3 fields I must w
aborruso wrote
> As I written in my message I'm able to use ogrinfo to alterate my source
> file, but if I want to add 3 fields I must write 3 ogrinfo statements; I
> would like to know why a single statemente with a correct SQL command.
ops, I'm sorry ... why I cannot use a single ogrinfo statem
I see. Thanks for the correction.
On Sun, May 1, 2016 at 6:58 AM, aborruso wrote:
> Hi Christine,
> thank you.
>
>
> Christine Waigl wrote
> >
> > As far as I'm aware -- please correct me if I'm wrong --
> > ogrinfo only lists information about a file and doesn't
> > alter it.
>
> As I written i
On 2016-05-01 10:30 AM, aborruso wrote:
jmckenna wrote
I think you have to use 2 ogrinfo statements.
I know it, it works with 2 statements. Do you know why I cannot use my kind
of SQL command with all in one statement?
And what do you think about to add some note in the documentation, about
Hi Jeff,
thank you from Italy!
jmckenna wrote
>
> When I responded earlier I was testing and you cannot do this in one
> single ogrinfo command (so that answers your initial question). What
> would be great, if you could add your working example to the docs: here
> is an existing wiki page f
Le dimanche 01 mai 2016 19:11:36, aborruso a écrit :
> Hi Jeff,
> thank you from Italy!
>
>
> jmckenna wrote
>
> > When I responded earlier I was testing and you cannot do this in one
> > single ogrinfo command (so that answers your initial question). What
> > would be great, if you could add y
Hi Even,
On 1 May 2016 at 22:28, Even Rouault wrote:
> Because it is not implemented... OGR SQL has many implementation
> limitations.
> What is supported is documented here : http://gdal.org/ogr_sql.html
>
thank you very much. I had read that page, but stupidly I did not think
that "ALTER TABL
Andrea Borruso wrote:
>thank you very much. I had read that page, but stupidly I did not think
>that "ALTER TABLE tablename ADD [COLUMN] columnname columntype" meant
>strictly that I could only use it in this way.
>My wrong intepretion was that I could use "alter table add" SQL command
>and its v
Hi Jukka,
Rahkonen Jukka (MML) wrote
> Do you know some database that accepts SQL "ALTER TABLE foo ADD COLUMN
> bar1, bar2"? At least SQLite and PostgreSQL don't. That kind of usage is
> not mentioned in a bunch of documents about SQL language which I browsed
> through, for example http://www.w3s
Andrea wrote:
>Hi Jukka,
>Rahkonen Jukka (MML) wrote
>> Do you know some database that accepts SQL "ALTER TABLE foo ADD COLUMN
>> bar1, bar2"? At least SQLite and PostgreSQL don't. That kind of usage is
>> not mentioned in a bunch of documents about SQL language which I browsed
>> throug
On 2 May 2016 at 09:32, Rahkonen Jukka (MML) [via OSGeo.org] <
ml-node+s1560n5263838...@n6.nabble.com> wrote:
> It seems to me that adding a general support for adding multiple columns
> with a single request into OGR SQL dialect would require to go through
> every driver: With PostgreSQL, build S
15 matches
Mail list logo