On 12/13/2012 06:51 PM, Alvaro Herrera wrote:
Alejandro Carrillo escribió:Hi, 1) Anybody knows how to create a table using a table file? It isn't a fdw, is a file that compose the table in postgresql and get with the pg_relation_filepath function. Ex: select pg_relation_filepath('pg_proc');Make sure the server is down and replace a table's file with the file you have. You can just create a dummy empty table with exactly the same row type as the one that had the table the file was for; you need to recreate dropped columns as well.
So it is possible to slide a file under a table? How exactly do you do that and keep the OID and filenode references in sync? -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
