Just wanna post snippet code import .sql file into particular database schema in PostgreSQL. Here is the command :
postgresql
PostgreSQL Converting Epoch (date long) to Formatted Date (vice versa)
Epoch : The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). Literally speaking the epoch is Unix time 0 (midnight 1/1/1970), but ‘epoch’ is often used as a synonym for […]
Sticky Code : Kill Process Session Database in PostgreSQL
Have you ever seen this error message when you are trying to delete particular DB ? This error message tells us that DB in used and cannot be dropped. And sometimes I feel little bit annoying because I don’t have much time to ask anyone who access / remote DB to close their connection. So what […]