Re: [pgadmin-support] how to view TOAST table

2010-02-08 Thread Guillaume Lelarge
Hi, Le 05/02/2010 06:50, Abhisekh Mohapatro a écrit : > [...] > I have a table which has a column with datatype BYTEA. > In order to trigger TOAST mechanism for the column, I have made the following > alteration. > > ALTER TABLE table_name ALTER COLUMN column_name SET STORAGE EXTERNAL > I adde

[pgadmin-support] how to view TOAST table

2010-02-04 Thread Abhisekh Mohapatro
Hi I have a table which has a column with datatype BYTEA. In order to trigger TOAST mechanism for the column, I have made the following alteration. ALTER TABLE table_name ALTER COLUMN column_name SET STORAGE EXTERNAL Please suggest me if I have to make any other changes. Also I am unable to vi