Start a new topic

@export function

[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

[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