In response to Rekha Ravi Pai : > Hi, > I want to copy a table say employeedetails from employee > database to library database. Can you help me giving the > detailed steps to do this. pg_dump -t <insert the table-name> <insert the source-db> | psql <insert destination db> In you case: pg_dump -t employeedetails employee | psql library Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general