How to export some columns from a schema?

[ogonzalesdiaz]

I need to export in a CSV only one column of my (extended) recipient schema.

The extenden recipients schema has the namespace "abc". 

I'm using a SQL code activity with: 

SELECT scodinternocomputacional
FROM nmsrecipient;

I have keep interim results activated, but I cannot display what data the SQL code is generating, to validate it is only the desired column.


If I use: 

SELECT scodinternocomputacional
FROM abcrecipient;

I get: 

10/01/2024 12:06:17 PM WDB-200001 SQL statement 'SELECT scodinternocomputacional FROM abcrecipient' could not be executed.
10/01/2024 12:06:17 PM PGS-220000 PostgreSQL error: ERROR: relation "abcrecipient" does not exist LINE 2: FROM abcrecipient ^ .

[DavidKangni · Accepted solution]

Hi @ogonzalesdiaz 

I will suggest you to just use a query activity 

1. Run the query with your criteria
2. add additional data and select the column needed
3. Click on advanced parameters and check the box "Disable automatic ..."
4. Optional: in case Advanced Parameters is not showing the first time, you need to save the query and reopen it. Then click on Edit additional data and It should be visible

The result will give you the column you select.

Thanks,

David