List all sequences in a Postgres db 8.1 with SQL
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 … Read more
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 … 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 … Read more
I have a small table and a certain field contains the type “character varying“. I’m trying to change it to “Integer” but it … 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 … 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 … 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 … Read more
I can’t find a definite answer to this question in the documentation. If a column is an array type, will all the entered … 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 … Read more
How can I list all the tables of a PostgreSQL database and order them by size? 12 Answers 12