Re(2): Copying a Database

From: "pgsql-admin" <pgsql-admin(at)fc(dot)emc(dot)com(dot)ph>
To: pgsql-admin(at)postgresql(dot)org, pginfo(at)ionsol(dot)com(dot)au
Subject: Re(2): Copying a Database
Date: 2000-12-20 07:37:43
Message-ID: fc.000f567200888446000f567200888446.88847d@fc.emc.com.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

a followup to my reply...
you can try 'copy'.

database=# \h copy
Command: COPY
Description: Copies data between files and tables
Syntax:
COPY [ BINARY ] table [ WITH OIDS ]
FROM { 'filename' | stdin }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]
COPY [ BINARY ] table [ WITH OIDS ]
TO { 'filename' | stdout }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]

sherwin

Browse pgsql-admin by date

  From Date Subject
Next Message jmlm 2000-12-20 08:44:37 Pb with more than 20 users
Previous Message pgsql-admin 2000-12-20 07:31:39 Re: Copying a Database