On Thu, 7 Oct 2004, Eyinagho Newton wrote:
Can anyone explain how postgreSQL reads from a text
file into tables already created in PostgreSQL?
Check out COPY command.
http://www.postgresql.org/docs/7.4/interactive/sql-copy.html
The file has to be in a certain format as explained in the
I wanted to know the contents of the buffer cache in 7.4, so I created
this function and view that seems to work ok:
/* Takes relfilenode (from pg_class) and returns the number of
* buffer cache pages it is using.
*/
PG_FUNCTION_INFO_V1(block_count);
Datum
block_count(PG_FUNCTION_ARGS)
{
On Fri, 21 Nov 2003, Matthew T. O'Connor wrote:
Do you know of an easy way to get a
count of the total pages used by a whole cluster?
Select sum(relpages) from pg_class.
You might want to exclude indexes from this calculation. Some large
read only tables might have indexes larger than the
