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

[Andreas Neumann]

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