Postgresql – Select statement to table with percentage column names

postgresql

I am selecting data from one table that have percentage sign in some column names like:

| name | val% | vale2% |

This table is ofted use with select * from table, but in this case I need only the field names with percentage sing, when I run a select in query tool of pgadmin this notice this error:

ERROR:  syntax error at or near "as"
LINE 1: SELECT val% as value, val2% as value2 from table

How I can run this query and get only val% and val% without the rest of fields.

NOTE: I can change the database structure, only query it data

Best Answer

Moved from comment to answer, as it seemed to resolve the OP's problem:

It sounds like the actual column names are causing your problem. If so, then you need to quote them somehow. Depending on the settings for your database:

SELECT "val%" as value, "val2%" as value2 from table

may work. In some SQL variants, you can use square brackets [] to quote column names that conflict with language keywords and operators:

SELECT [val%] as value, [val2%] as value2 from table

Related Solutions

Postgresql – Select one column by two different names in the same query

 select n1.name as "n1", n2.name as "n2"
 from main n1, main n2
 where n1.name = 'Ahmad'
     and n2.name = 'Sami';

Sql-server – Update Local Table With Data From Linked Server Using Open Query

So OPENQUERY() is basically saying "Open this query on the linked server" - It's the preferred method for doing a select when able for me. Instead of saying something like

SELECT col1, col2
FROM LinkedServerName.DatabaseName.Schema.Table
WHERE SomeValue = Something Local Here

it does the filtering and joining at the linked server. This avoids you having to bring data back to just filter it out, etc with the four part query aproach.

The problem, though, is that update is trying to run on the destination. It's basically a pass-through query, so you are trying to pass that update through.

So you'll need to do the update locally, but can join to the open query to join to the data on the other side. For more you can see the syntax guide here with some notes.

Best Answer

Related Solutions

Postgresql – Select one column by two different names in the same query

Sql-server – Update Local Table With Data From Linked Server Using Open Query

Related Question