Thread: Export a database or a table from a database
Hello, I want to export a database or a table from a database. There is a possibility the copy the data from the table, but I need the whole structure include the data. Regards Stefan
On Wed, 2002-03-06 at 11:43, Stefan Kowalski wrote: > Hello, > > I want to export a database or a table from a database. > There is a possibility the copy the data from the table, but > I need the whole structure include the data. pg_dump -d database [-t table] -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "The LORD is my light and my salvation; whom shall I fear? the LORD is the strength of my life; of whom shall I be afraid?" Psalms 27:1
Le Mercredi 6 Mars 2002 12:43, Stefan Kowalski a écrit : > I want to export a database or a table from a database. > There is a possibility the copy the data from the table, but > I need the whole structure include the data. all data : pg_dump -u > file_name.sql only a table : pg_dump -u --table=TABLE_NAME > file_name.sql For a complete list of pg_dump options, pg_dump --help /JMP
On Wed, 06 Mar 2002 06:43:34 -0500, Stefan Kowalski wrote: > I want to export a database or a table from a database. There is a > possibility the copy the data from the table, but I need the whole > structure include the data. $ man pg_dump -- Jeff Boes vox 616.226.9550 Database Engineer fax 616.349.9076 Nexcerpt, Inc. jboes@nexcerpt.com
>>>>> "SK" == Stefan Kowalski <Stefan.Kowalski@ixtra.com> writes: SK> I want to export a database or a table from a database. SK> There is a possibility the copy the data from the table, but SK> I need the whole structure include the data. Have you read the man page for pg_dump at all? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/