Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM ( SELECT * FROM dblink('dbname=db port=5432 host=dbhost user=dbuser password=dbpassword',
- 'SELECT column_1, column_2, date_in FROM table t WHERE t.date_in >= $P{start_date}') AS check_table(column_1 INTEGER, column_2 text, date_in DATE) ) AS b ORDER BY checkout_number
Add Comment
Please, Sign In to add comment