Hi people,
just a rapid question related to linux
How can I get the files in a directory, but not the
last file updated/created?
I could get the last file updated with:
ls -t1p | grep -v / | grep -v backup | head -1
How can I get the inverse list, other files without
the last??
Thank you in ad
Hi people,
I would like to some suggestion to search person name
in a table that has more than 150 milions of rows ...
e.g ... name like 'JOHN%SMITH';
I know there is contrib Tsearch, but I can't for
political reasons.
Is there any way to do with good performance???
Thank you.
Abra sua
Sorry to insist in this question, but now I was doing
some test and I notice that is a good idea to use
split utility.
This is because the output file got X bytes specified,
cut the rest of the line and will not import after.
In my example, I generated more than 2 files equal to
1MB. But already
t;[EMAIL PROTECTED]> escreveu:
> On Dec 17, 2007 2:06 PM, A.Burbello
> <[EMAIL PROTECTED]> wrote:
> > I consider this way a good practice to transport
> the
> > files. This is because I have table that has more
> than
> > 30GB.
> > But if the OS was win
$ pg_dump postgres -U postgres -f split.txt |
split --bytes=10m
Thank you.
--- Scott Marlowe <[EMAIL PROTECTED]> escreveu:
> On Dec 15, 2007 11:42 AM, A.Burbello
> <[EMAIL PROTECTED]> wrote:
> > Hi people,
> >
> > How can I export (dump) database more than
Hi people,
How can I export (dump) database more than 1 file?
I have great table and can't split.
Like Oracle, just set the parameter filesize and the
files name, and dump in several files.
Could I do it the same way in PG?
Thank you in advance.
Abra sua conta no Yahoo! Mail, o único sem
Hi people,
I have a case and I got a doubt what should be the
best ways.
One table has more than 150 million of rows, and I
thought that could divided by state.
For each row has person ID, state and other
informations, but the search would be done only by
person ID (number column).
I can improve
