Guest User

Untitled

a guest
Apr 4th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. SCRIPT TO 'fileName'
  2.  
  3. psql realdb < myfile.sql
  4.  
  5. ERROR: syntax error at or near "."
  6. LINE 1: ...TER TABLE PUBLIC.FILE_RECORD ADD CONSTRAINT PUBLIC.CONSTRAIN...
  7. ^
  8. ERROR: syntax error at or near "CACHED"
  9. LINE 1: CREATE CACHED TABLE PUBLIC.NODE_EVENT(
  10. ^
  11. ERROR: syntax error at or near "."
  12. LINE 1: ...LTER TABLE PUBLIC.NODE_EVENT ADD CONSTRAINT PUBLIC.CONSTRAIN...
  13. ^
  14. ERROR: relation "public.node_event" does not exist
  15. LINE 1: INSERT INTO PUBLIC.NODE_EVENT(ID, DAY, HOUR, MINUTE, MONTH, ...
  16. ^
  17. NOTICE: table "system_lob_stream" does not exist, skipping
  18. DROP TABLE
  19. ERROR: syntax error at or near "CALL"
  20. LINE 1: CALL SYSTEM_COMBINE_BLOB(-1);
  21.  
  22. call CSVWRITE( '/home/lee/test.csv' , 'SELECT * FROM PORT' )
  23.  
  24. spring.datasource.url=jdbc:h2:/tmp/ossdb:testdb;MODE=PostgreSQL
  25. spring.datasource.username=admin
  26. spring.datasource.password=admin
  27. spring.datasource.platform=postgresql
Add Comment
Please, Sign In to add comment