05-02-2013
ok. so it looks like "wc -c" is the answer here? it gives the exact same numbers as "ls -l". difference is, with "wc -c", the file size will always be in the first column. that's perfect! not too sure about the potential overhead though, if there ever is one.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
We have two files /var/adm/wtmp and /var/opt/OV/tmp/OpC/guiagtdf
Could you please tell me if what these files are and if I can purge them as they are very big and Vi will not let me look at them, it gives me a message 'file to long'.
Help any ideas
Thanks
:cool: (3 Replies)
Discussion started by: A Roberts
3 Replies
2. HP-UX
Hi All,
Currently we are using HP-UX machine.. We are facing problems with respect to file size. The file size does not seem to be exceeding 2 GB.
Could you please let me know the following
1. Is there any difference between a 32 bit application and 64 bit application with respect to file... (2 Replies)
Discussion started by: krishna7
2 Replies
3. Shell Programming and Scripting
hi ,
iam trying to sort millions of records which is delimited and i cant able to
use sort command more than 60 million..if i try to do so i got an message stating that "File size limit exceeded",Is there any file size limit for using sort command..
How can i solve this problem.
thanks
... (7 Replies)
Discussion started by: cskumar
7 Replies
4. Filesystems, Disks and Memory
Hi,
when can a unix library file size become zero? For example.: can mistyping this command -> /usr/ucb/ps -auxww|grep -i <process name> make the "ps" library file size to become zero or its contents to get deleted? Is there any other way that an inadvertant mistake could cause the file size to... (1 Reply)
Discussion started by: ananthmm
1 Replies
5. UNIX for Dummies Questions & Answers
I have a file on solaris/linux.
ls -ls shows the logical size to be: 13292
However, when I transfer the file to my windows machine.. Rightclick->Properties shows the file size as: 13421
I wrote a small program on unix and windows that does a stat() on the file and reports the st_size... (6 Replies)
Discussion started by: the_learner
6 Replies
6. UNIX for Dummies Questions & Answers
What's the maximum file size supported by unix. (3 Replies)
Discussion started by: nagalenoj
3 Replies
7. UNIX for Dummies Questions & Answers
Hi everybody ,
I'm new here in the forum and new Dummy in L|U systems (Hope finding welcomes...:)).
I just want to ask : What is the OS's that works on servers and the OS's that work as client OS??
I just know that Solaris Work on sarvers :D..
and i'm glad to be memmber in this... (1 Reply)
Discussion started by: derbi
1 Replies
8. UNIX for Advanced & Expert Users
Anybody can help
HOW TO FIND THE FILE SIZE IN UNIX (5 Replies)
Discussion started by: lmraochodisetti
5 Replies
9. Shell Programming and Scripting
Hi,
I have a file by redirecting some contents in unix shell.
Even when there is no content that is being redirected, the file size still shows greater than zero.
but even if there is no matching pattern the file APPRES has size greater than 0bytes.
awk -f AA.awk $logfile>APPRES... (3 Replies)
Discussion started by: justchill
3 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
I am trying to sftp, get a file from remote server.
Post this we need to check the remote server file size or checksum value of the remote server file and compare it with the file size in the current server.
But I am facing issue to get the remote server file size. Could you please... (2 Replies)
Discussion started by: abhi_123
2 Replies
LEARN ABOUT CENTOS
dblink_build_sql_delete
DBLINK_BUILD_SQL_DELETE(3) PostgreSQL 9.2.7 Documentation DBLINK_BUILD_SQL_DELETE(3)
NAME
dblink_build_sql_delete - builds a DELETE statement using supplied values for primary key field values
SYNOPSIS
dblink_build_sql_delete(text relname,
int2vector primary_key_attnums,
integer num_primary_key_atts,
text[] tgt_pk_att_vals_array) returns text
DESCRIPTION
dblink_build_sql_delete can be useful in doing selective replication of a local table to a remote database. It builds a SQL DELETE command
that will delete the row with the given primary key values.
ARGUMENTS
relname
Name of a local relation, for example foo or myschema.mytab. Include double quotes if the name is mixed-case or contains special
characters, for example "FooBar"; without quotes, the string will be folded to lower case.
primary_key_attnums
Attribute numbers (1-based) of the primary key fields, for example 1 2.
num_primary_key_atts
The number of primary key fields.
tgt_pk_att_vals_array
Values of the primary key fields to be used in the resulting DELETE command. Each field is represented in text form.
RETURN VALUE
Returns the requested SQL statement as text.
NOTES
As of PostgreSQL 9.0, the attribute numbers in primary_key_attnums are interpreted as logical column numbers, corresponding to the column's
position in SELECT * FROM relname. Previous versions interpreted the numbers as physical column positions. There is a difference if any
column(s) to the left of the indicated column have been dropped during the lifetime of the table.
EXAMPLES
SELECT dblink_build_sql_delete('"MyFoo"', '1 2', 2, '{"1", "b"}');
dblink_build_sql_delete
---------------------------------------------
DELETE FROM "MyFoo" WHERE f1='1' AND f2='b'
(1 row)
PostgreSQL 9.2.7 2014-02-17 DBLINK_BUILD_SQL_DELETE(3)