IT Nursery > News > postgresql

postgresql

Programming, sql

IT Nursery

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 ...

June 3, 2022
0 Comments

Java, Programming

IT Nursery

Is it possible to specify the schema when connecting to postgres with JDBC?

Is it possible? Can i specify it on the connection URL? How to do that? 8 Answers 8

June 2, 2022
0 Comments

postgresql, Programming

IT Nursery

Which data type for latitude and longitude?

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 ...

June 2, 2022
0 Comments

postgresql, Programming

IT Nursery

Change type of varchar field to integer: “cannot be cast automatically to type integer”

I have a small table and a certain field contains the type “character varying“. I’m trying to change it to “Integer” but it ...

June 2, 2022
0 Comments

macos, Programming

IT Nursery

Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?

This question may look like a duplicate of: How to uninstall postgresql on my Mac (running Snow Leopard) however, there are two major ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

How big is too big for a PostgreSQL table?

I’m working on the design for a RoR project for my company, and our development team has already run into a bit of ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

How to alter a column’s data type in a PostgreSQL table?

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 ...

June 2, 2022
0 Comments

arrays, Programming

IT Nursery

Can PostgreSQL index array columns?

I can’t find a definite answer to this question in the documentation. If a column is an array type, will all the entered ...

June 2, 2022
0 Comments

Programming, ruby-on-rails

IT Nursery

Repairing Postgresql after upgrading to OSX 10.7 Lion

I recently upgraded to OSX 10.7, at which point my rails installation completely borked when trying to connect to the psql server. When ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

postgresql list and order tables by size

How can I list all the tables of a PostgreSQL database and order them by size? 12 Answers 12

June 1, 2022
0 Comments