0
votes
0answers
109 views

pgAdmin III - how to insert data into table

How can I insert the result of some function (e.g. point(0,0) or localtimestamp) into some cell in the edit data window of pgAdmin? I keep getting an error Invalid input syntax for type ...
1
vote
2answers
936 views

software tools for cleaning up messy data (flat files, Excel etc) semi-automatically?

I routinely receive files, usually Excel spreadsheets, which contain manually-entered data that have outgrown the utility of spreadsheets. I then clean up these files for import into a database. ...