[ADMIN] dumping tables in non-public schemas..

HI, How do we dump a particular schema qualified table using pg_dump? pg_dump -t shema.tablename database_name does not seems to work regds mallah. -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit

[ADMIN] How to separate data and index objects on different disks???

Does anyone have a solution to put data files with table objects on separate disks than data files with index objects? For Oracle this is simple, but for PostgreSQL I am not sure how to do this. Does anyone know? TIA. __ Do you Yahoo!? Yahoo! Mail

Re: [ADMIN] HELP? Postgres filling up disk

will do! I'll let you know how it goes but it will be after xmas cause we can have no down-time right now. thanks! "Tom Lane" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > "HT" <[EMAIL PROTECTED]> writes: > > $ ls -l 3828262123* > > -rw--- 1 postgres

Re: [ADMIN] HELP? Postgres filling up disk

"HT" <[EMAIL PROTECTED]> writes: > $ ls -l 3828262123* > -rw--- 1 postgres postgres 1073741824 Dec 18 23:08 3828262123 > -rw--- 1 postgres postgres 558899200 Dec 18 23:16 3828262123.1 Okay, that looks more plausible. I think you need a VACUUM FULL to recover the wasted space in the ma

Re: [ADMIN] HELP? Postgres filling up disk

Sorry, I've spent much time examining this in detail, so if I neglected the * in the transcript I pasted you, it still doesn't matter. There is a .1 version (see my transcript below), BUT THAT'S IT . So my original argument is still unanswered: there are still extra files on production tha

Re: [ADMIN] Sybase PowerDesigner Data Architect

On 19 Dec 2002 at 8:57, Dan Langille wrote: > The two remaining problems are: > > - default values are always enclosed in single quotes (') which is > fine for character fields but not for anything else. > > e.g > > create table security_notice > ( > id T_ID

[ADMIN] Sybase PowerDesigner Data Architect

I've been using this tool for a number of years. I'm using verion 6.1.3 and it meets my needs when it comes to PostgreSQL development. I recently found the "PowerDesigner Definition File Library" at http://www.datamodel.org/PowerDesigner/progress.def. Alain Lavigne has created a definition fi

[ADMIN] Accessing PgSQL from Microsoft Based based platforms..

Hi, Is ODBC (pgsqlodbc) the only way for MS based platforms to access pgsql. eg thru perl we can use ODBC or DBI to access PHP has native support (--with-pgsql) for accessing pgsql . regds mallah. -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi p

Re: [ADMIN] Strange behaviour ( function cachable )

"Tom Lane" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > "Gaetano Mendola" <[EMAIL PROTECTED]> writes: > > I expected that if a function is cachable and is used > > inside a select like: > > SELECT * FROM foo WHERE id = my_func( a_param ) > > then the functio