sc_exec_sql with postgresql

Scriptcase 9 General
#1

sc_exec_sql(" CREATE TABLE pong8_two_stock_Data19 as SELECT “public”.“pong8_One_Stock_Varchar”.“Last” , “public”.“pong8_One_Stock_Varchar”.“Turnover” FROM “public”.“pong8_One_Stock_Varchar” ")

I try this code it not work

This code I test with scriptcase sql builder it work Please suggest how can I fix it

#2

sc_exec_sql(“CREATE TABLE pong8_two_stock_Data19 as SELECT public.pong8_One_Stock_Varchar.Last , public.pong8_One_Stock_Varchar.Turnover FROM public.pong8_One_Stock_Varchar”)

See: http://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
Your double quotes are confusing. Use them only when needed and it you use it in a function like sc_exec_sql be sure to use the proper quotes.

#3

I use postgresql when i try

sc_exec_sql(“CREATE TABLE pong8_two_stock_Data19 as SELECT public.pong8_One_Stock_Varchar.Last , public.pong8_One_Stock_Varchar.Turnover FROM public.pong8_One_Stock_Varchar”)

[TABLE=“class: scErrorTable, align: center, cellpadding: 0, cellspacing: 0”]
[TR]
[TD=“class: scErrorTitle, align: left”]Error[/TD]
[/TR]
[TR]
[TD=“class: scErrorMessage, align: center”]pg_query(): Query failed: ERROR: relation “public.pong8_one_stock_varchar” does not exist LINE 1: …st , public.pong8_One_Stock_Varchar.Turnover FROM public.pon… ^[/TD]
[/TR]
[/TABLE]
[TABLE=“class: scErrorTable, align: center, cellpadding: 0, cellspacing: 0”]
[TR]
[TD=“class: scErrorTitle, align: left”]Error[/TD]
[/TR]
[TR]
[TD=“class: scErrorMessage, align: center”]Error while accessing the database:
ERROR: relation “public.pong8_one_stock_varchar” does not exist LINE 1: …st , public.pong8_One_Stock_Varchar.Turnover FROM public.pon… ^[/TD]
[/TR]
[/TABLE]

#4

Ok I am officially baffled… as I would have expected it to work. Then again my postgress skills are not up to date. I prefer mysql and maria.