how to get column size and type through my database in PostgreSQL

sql postgresql pgadmin
Õzbek picture Õzbek · Dec 17, 2010 · Viewed 46k times · Source

I've changed column length manually in my previous database.

But after creating new database via HQL it's creating varchar(255) and I need to make it longer.

I need to find which table's column should I change?

I can find it manually but now I have about 200 tables and I need a query to do this.

How can I get the column type and its length in Postgres using a SQL query?

Answer

D'Arcy Rittich picture D'Arcy Rittich · Dec 17, 2010

The INFORMATION_SCHEMA tables will help you here:

select *
from INFORMATION_SCHEMA.COLUMNS

You can examine the table_name, column_name, data_type and character_maximum_length columns in the result set.

Related questions

How to visualize database tables in postgresql using pgAdmin?

I am trying to visualize tables and their relations using pgAdmin. I have understood that there is a query visualizer tool available for pgAdmin. However, that only is useful if you are dealing with queries. My main goal is to …

Read More
Create an ER diagram in pgAdmin

What would be the step by step walk-through for building a basic Entity-Relationship Diagram from pgAdmin? Would there be some plugins for doing that in pgAdmin? Note: I searched in the web but other than stumbling upon an exhausting list …

Read More
How restore postgreSQL dump file using pgAdmin?

I've a .dmp file. Want to restore the database from it. Using pgAdmin how can I do it?

Read More