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 added a ticket because it seems we can't change the storage information (http://code.pgadmin.org/trac/ticket/134). > Please suggest me if I have to make any other changes. > Also I am unable to view the TOAST table. > > Please help me out in viewing the table. > Why would you like to "see"/"view" the TOAST table? I don't see the advantages of this. The TOAST table seems more an implemantation detail. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
