Forum Discussion
Anonymous
5 years agoNot applicable
How can I connect postgreSQL with native SQL queries
I plan to select the last item by date and time listed in the table.
Table.Buffer() make my refresh time significantly slower.
1. Will it be better if I do it with SQL ?
2. How could I manually enter SQL query since there is no advance option in PostgreSQL connection option.
M code are below :
let
Source = PostgreSQL.Database("xx.xxx.xxx.xx:port", "db-name"),
sc_aaa_vw_aaa_info = Source{[Schema="sc_aaa",Item="vw_aaa_info"]}[Data],
....
in
...
Anonymous , Try if connecting via ODBC can allow you to give query
1 Reply
- amitchandakSuper User
Anonymous , Try if connecting via ODBC can allow you to give query