I had an interesting month?
This last month I have had to transfer data from one database to another.
I found this somewhat difficult and frustrating as my knowledge of SQL scripting/ftp is very basic and what I know is basically stuff I have taught my-self.
The database I look after is controlled by pgAdmin (PostgreSQL), which is connected to the companies database server.
I wanting to create an sql script (select statement) to generate a report from different tables.
I know how to do this from one table but from multiple table I find it hard. I haven't really had much experience in this field. But I'm learning as I go...
Anyway I ended up copying and pasting the data into excel sheets as I found it easier!
I know it would have been heaps easier to have written a script but this was a quick solution until I get better a more confident in this area....
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment