Guest User

Untitled

a guest
Jan 15th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. SELECT *
  2.  
  3. FROM ( SELECT * FROM dblink('dbname=db port=5432 host=dbhost user=dbuser password=dbpassword',
  4.  
  5. '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