Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pg data type of osm_timestamp colum is text but not timestamp(0) #168

Closed
thbeutin opened this issue Jul 10, 2014 · 1 comment
Closed

pg data type of osm_timestamp colum is text but not timestamp(0) #168

thbeutin opened this issue Jul 10, 2014 · 1 comment

Comments

@thbeutin
Copy link

after adding the required line to the style file and importing OSM data with --extra-attributes the tables planet_osm_point, _line and _polygon cotains the column osm_timestamp, but unfortunately the datatype is text. I'd like to have a standard (p)sql data type timestamp(0) for space and usage reasons - is this possible?

@thbeutin
Copy link
Author

thbeutin commented Aug 8, 2014

Ok, this was a sloppy investigation on my side - if i use a line like:
"node,way osm_timestamp timestamp(0)"
in the style i get the timestamp as a correct (postgre)sql value.
but this seems not to work if i use pbf input data - i'll open a separate issue on this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant