I usually place the username and password on the vsql command line in scripts. However, the "ps" command will show the command line of the process to other users, thus revealing the username and password for the account! Is it possible to hide the password from other users when they invoke "ps"?

nnani/scutter,

Thanks for the help! I'll incorporate a daily check that looks for stale and no statistics and run the analyze_statistics funcntion on tables I load during the ETL.

Hi,

Is there a best practice for how often table statistics need to be refreshed? How can I tell which tables have out of date statistics?

Thanks!

Sorry, skwa, call me stupid, but I still don't understand the difference. Even after reading the documentation. Keep in mind I'm a dba just out a college so I am a newbie to the extreme (pls be gentle).

Hello, Is there a difference between the SUBSTR() vs SUBSTRING() functions? There doesn't appear to be. dbadmin=> select substr('whatisthedifference', 10), substring('whatisthedifference', 10); substr | substring ------------+------------ difference | difference (1 row) Why do they both exist if the...

Thank you for responding to my question, Jim. The method of extracting the data into a flat file and then loading it later via the copy command will work for us.

You said "There isn't an easy way to export data as insert statements.", so what's the hard way

Hi,

Is it possible to export data from a table into a script in the form of insert statements? This is an nice feature in MySQL. I would like to have backup scripts that I can use to easily reload dimension tables.

Thanks!!!