Home > mailing lists

\copy only select rows - Mailing list pgsql-general

From	Ow Mun Heng
Subject	\copy only select rows
Date	August 30, 2007 07:00:31
Msg-id	1188457146.18203.51.camel@neuromancer.home.net Whole thread Raw
Responses	Re: \copy only select rows ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List	pgsql-general

Is there a way to do a dump of a database using a select statement?

eg: \copy trd to 'file' select * from table limit 10

From: Denis Gasparin
Date: 30 August 2007, 06:37:39
Subject: Re: Question regarding autovacuum in 8.1

From: "A. Kretschmer"
Date: 30 August 2007, 07:15:04
Subject: Re: \copy only select rows