Re: [GENERAL] postgres import

2006-11-02 Thread Tomi NA
2006/11/2, Albe Laurenz <[EMAIL PROTECTED]>: psql -h host -p port -d database -U user >> >>> It's a good enough solution in most cases, but when the rowcount >>> starts to skyrocket, it simply doesn't seem to cut it (at least I >>> couldn't make it to). >> >> INSERT statements? You dumped wi

Re: [GENERAL] postgres import

2006-11-02 Thread Albe Laurenz
psql -h host -p port -d database -U user >> >>> It's a good enough solution in most cases, but when the rowcount >>> starts to skyrocket, it simply doesn't seem to cut it (at least I >>> couldn't make it to). >> >> INSERT statements? You dumped with the -d flag, didn't you? > > No I didn't, a

Re: [GENERAL] postgres import

2006-11-01 Thread Tomi NA
2006/11/1, Alban Hertroys <[EMAIL PROTECTED]>: Tomi NA wrote: > 2006/10/31, Albe Laurenz <[EMAIL PROTECTED]>: >> You feed it to the command line interface psql. >> >> Example: >> psql -h host -p port -d database -U user > It's a good enough solution in most cases, but when the rowcount > starts

Re: [GENERAL] postgres import

2006-11-01 Thread Alban Hertroys
Tomi NA wrote: 2006/10/31, Albe Laurenz <[EMAIL PROTECTED]>: You feed it to the command line interface psql. Example: psql -h host -p port -d database -U user It's a good enough solution in most cases, but when the rowcount starts to skyrocket, it simply doesn't seem to cut it (at least I cou

Re: [GENERAL] postgres import

2006-10-31 Thread Tom Lane
"Tomi NA" <[EMAIL PROTECTED]> writes: > 2006/10/31, Albe Laurenz <[EMAIL PROTECTED]>: >> psql -h host -p port -d database -U user It's a good enough solution in most cases, but when the rowcount > starts to skyrocket, it simply doesn't seem to cut it (at least I > couldn't make it to). It certain

Text manipulation tools (was Re: [GENERAL] postgres import)

2006-10-31 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/31/06 17:17, Tomi NA wrote: > 2006/10/31, Albe Laurenz <[EMAIL PROTECTED]>: [snip] > It's a good enough solution in most cases, but when the rowcount > starts to skyrocket, it simply doesn't seem to cut it (at least I > couldn't make it to). To l

Re: [GENERAL] postgres import

2006-10-31 Thread Tomi NA
2006/10/31, Albe Laurenz <[EMAIL PROTECTED]>: > I have a little problem. I have an .sql file ( db dump ) > and i want to import it to postgres on linux. > > Does anyone know how i can do it? You feed it to the command line interface psql. Example: psql -h host -p port -d database -U user It

Re: [GENERAL] postgres import

2006-10-31 Thread Albe Laurenz
> I have a little problem. I have an .sql file ( db dump ) > and i want to import it to postgres on linux. > > Does anyone know how i can do it? You feed it to the command line interface psql. Example: psql -h host -p port -d database -U user http://www.postgresql.org/docs/faq