Re: copy limited number of records
От | Oliver Elphick |
---|---|
Тема | Re: copy limited number of records |
Дата | |
Msg-id | 1036424862.1106.323.camel@linda обсуждение исходный текст |
Ответ на | copy limited number of records ("Johnson, Shaunn" <SJohnson6@bcbsm.com>) |
Ответы |
Re: copy limited number of records
|
Список | pgsql-general |
On Mon, 2002-11-04 at 15:02, Johnson, Shaunn wrote: > Howdy: > > Running PostgreSQL 7.2.1 on RedHat Linux 7.2. > > I'm using copy to create a bunch of flat files with delimiters > and it's going okay. I've been asked, however, that the clients > don't actually want ALL of the data in the table; perhaps about > 100 or so records for testing. > > Is there a way to use limit while using the \copy command? > (e.g., \copy t_test_tbl to '/usr/local/home/admin/dev_tbls' using delimiters > ',' limit 10) > > I know the above doesn't work, but, perhaps there is a work around? You can use Unix commands: head -100 /usr/local/home/admin/dev_tbls | psql -d your_db -c "COPY t_test_tbl FROM STDIN" -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "Lo, children are an heritage of the LORD; and the fruit of the womb is his reward." Psalms 127:3
В списке pgsql-general по дате отправления: