Start a new topic

@export function

anonymous

started a topic almost 16 years ago

[This topic is migrated from our old forums. The original author name has been removed]

I am using @export function to export data , is there a way to create file names in a dinamically way , 
*Example :* 
To create a daily file:
*TableNameyyyymmdd.csv*
I was seeing you have an sample with {table} variable, Are there other variables that i can use? Can i concatenate that variable with a string?

Best Regards and Thanks a lot for your help

1 Comment

Roger Bjärevall

said almost 16 years ago

[This reply is migrated from our old forums.]

Re: @export function

Oscar,

The only supported variable in this context is the ${table} variable.

However, you may enclose the variable with text such as:

@export set filename="/tmp/${table}-20080715.csv" format="csv";
@export on;
select * from myTable;

I'll register a feature request so that date, time and timestamp variables will be supported also.

Best Regards

Roger

How can we help you today?

@export function

anonymous

Roger Bjärevall