[Qgis-user] How to get rid of table name while joining table

[Matthias Kuhn]

That was probably me at the same time...

Looking into it right now,
thank you for reporting

On 23.01.2015 10:43, Andreas Neumann wrote:
> Excellent - thanks for this modification!
>
> I noticed that there is a regression. The GUI to choose certain
> columns from the joined table is always deactivated. So no chance
> anymore to select certain fields.
>
> I don't know when this regression was introduced.
>
> Tested with PostgreSQL tables.
>
> I opened a bug report: http://hub.qgis.org/issues/12042
>
> Andreas
>
> On 22.01.2015 16:39, Matthias Kuhn wrote:
>> I just merged this functionality.
>> When you create a join, you may specify a prefix. This can be an empty
>> string.
>> By default it is unspecified and "layername_" is used, so it is exactly
>> like before.
>>
>> Best,
>> Matthias
>>
>> On 20.01.2015 11:25, Nathan Woodrow wrote:
>>> I think leaving it up to the user is the best option here.
>>>
>>> Nathan
>>>
>>> On Tue, 20 Jan 2015 8:17 pm Andreas Neumann <a.neumann at carto.net>
>>> wrote:
>>>
>>>>   Then you can't distinguish a joined column from a normal column.
>>>> And it
>>>> would open up naming conflicts - which is the reason why the layer
>>>> name
>>>> prefix was introduced. Bad, in my opinion.
>>>>
>>>>
>>>> Andreas
>>>>
>>>>
>>>> On 20.01.2015 11:01, Harish wrote:
>>>>
>>>>   Thanks for kind replies. A feature request for adding an option to
>>>> not prepend layer names will be better.
>>>>   Regards
>>>>
>>>> On Tue, Jan 20, 2015 at 3:18 PM, Andreas Neumann <a.neumann at carto.net>
>>>> wrote:
>>>>
>>>>> or - the even better way would be to allow the user to define a very
>>>>> short user-defined table name prefix (1-3 chars).
>>>>>
>>>>> Andreas
>>>>>
>>>>>
>>>>> On 20.01.2015 10:45, Anita Graser wrote:
>>>>>
>>>>>>   On Tue, Jan 20, 2015 at 9:41 AM, Harish
>>>>>> <harry.om2000 at gmail.com> wrote:
>>>>>>
>>>>>>> I do not want name of table to be included in attribute names when
>>>>>>> joining
>>>>>>> tabular data to vector layers which are further truncated when
>>>>>>> saving
>>>>>>> the
>>>>>>> layer permanently.
>>>>>>>
>>>>>> Hi Harish,
>>>>>> Layer names are prepended to avoid troube with columns having the
>>>>>> same
>>>>>> name (often the case with "id" or "name" columns).
>>>>>> You can change the layer name to empty, then only an underscore _
>>>>>> will
>>>>>> be prepended - this saves characters.
>>>>>> An alternative is to open a feature request for adding an option to
>>>>>> not prepend layer names.
>>>>>> Best wishes,
>>>>>> Anita
>>>>>>   _______________________________________________
>>>>>> Qgis-user mailing list
>>>>>> Qgis-user at lists.osgeo.org
>>>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>>>
>>>>> _______________________________________________
>>>>> Qgis-user mailing list
>>>>> Qgis-user at lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>>
>>>>   _______________________________________________
>>>> Qgis-user mailing list
>>>> Qgis-user at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user