to look at a table scheme in PG in heroku && change a table type Production or Staging --- POSTGRESQL

gistfile1.txt

1. first run the pg version of dbconsole in heroku by using this command :

	heroku pg:psql --remote heroku (<staging>)

2. list the tables in psql by using this command
	
	\dt

3. get the proper name of the table and list the schema by using this command

	\d <table_name>

viola! - there is your scheme 

to CHANGE a column TYPE 

ALTER TABLE <table name> ALTER COLUMN <column name> SET DATA TYPE <new type> 

NOTE - this did not work for me because i need a type transfer system which i was unable to locate
so I just made rails migrations that dropped the column and added a new column same name with correct data type 

to look at the actual data

SELECT * from table_name