I’m converting a db from postgres to mysql. Since i cannot find a tool that does the trick itself, i’m going to convert all postgres sequences to autoincrement ids in mysql with autoincrement value. So, how can i list all sequences in a Postgres DB (8.1 version) with information about the table in which it’s … Read more
Is it possible? Can i specify it on the connection URL? How to do that? 8 Answers 8
I am newbie to PostgreSQL and PostGIS. I want to store latitude and longitude values in PostgreSQL 9.1.1 database table. I will calculate distance between two points, find nearer points by using this location values. Which data type should I use for latitude and longitude? 6 Answers 6
I have a small table and a certain field contains the type “character varying“. I’m trying to change it to “Integer” but it gives an error that casting is not possible. Is there a way around this or should I just create another table and bring the records into it using a query. The field … Read more
This question may look like a duplicate of: How to uninstall postgresql on my Mac (running Snow Leopard) however, there are two major differences. I’m running Lion and I’m trying to uninstall PostgreSQL 9.0.4. I’ve looked at the last question and the link that it referenced, but I did not find a file called “uninstall-postgresql” … Read more
I’m working on the design for a RoR project for my company, and our development team has already run into a bit of a debate about the design, specifically the database. We have a model called Message that needs to be persisted. It’s a very, very small model with only three db columns other than … Read more
Entering the following command into a PostgreSQL interactive terminal results in an error: ALTER TABLE tbl_name ALTER COLUMN col_name varchar (11); What is the correct command to alter the data type of a column? 3 Answers 3
I can’t find a definite answer to this question in the documentation. If a column is an array type, will all the entered values be individually indexed? I created a simple table with one int[] column, and put a unique index on it. I noticed that I couldn’t add the same array of ints, which … Read more
I recently upgraded to OSX 10.7, at which point my rails installation completely borked when trying to connect to the psql server. When I do it from the command line using psql -U postgres it works totally fine, but when I try to run the rails server or console with the same username and password, … Read more
How can I list all the tables of a PostgreSQL database and order them by size? 12 Answers 12