I have a comments on tables in my database.
e.g. COMMENT ON TABLE my_schema.my_table IS 'Employee Information';
I know you can get comments using \d+
Is there a way to select comments?
Reason: I do a lot of perl interfaces. I find escape commands do not
work using DBI.
Thanks,
Ari
--
afuoco wrote:
why not just
update pg_database set datname='foodmart' where datname like
'foodmart%';
------ Original Message ---
From: Ari Kahn <[EMAIL PROTECTED]>
To: Tom Lane <[EMAIL PROTECTED]>
Cc: Stephen Frost <[EMAIL PROTECTED]>, pg
On Apr 25, 2006, at 10:51 AM, Tom Lane wrote:
Ari Kahn <[EMAIL PROTECTED]> writes:
You'll notice the database foodmart has a carriage return or new
line. I still can't figure out how to get rid of it though.
Perhaps something along the lines of
drop da
On Apr 25, 2006, at 8:46 AM, Stephen Frost wrote:
* Ari Kahn ([EMAIL PROTECTED]) wrote:
That was a good idea. But this is not the case.
You might try just looking at pg_database directly:
select * from pg_database;
Or (as someone else suggested) pipeing the output into a file which
you
On Apr 25, 2006, at 3:25 AM, Tom Lane wrote:
Ari Kahn <[EMAIL PROTECTED]> writes:
I was trying to dump all my databases:
su - postgres
/usr/local/bin/pg_dumpall > /Volumes/Space/postgresql_060425.dump
I get:
" does not exist database "foodmartto database "food
I was trying to dump all my databases:
su - postgres
/usr/local/bin/pg_dumpall > /Volumes/Space/postgresql_060425.dump
I get:
" does not exist database "foodmartto database "foodmart
", exiting: pg_dump failed on database "foodmart
I guess I had a database called foodmart at one time. However,
Could you be more specific. It seems that lots of people get this
error message on many platforms.
Ari
On Jan 11, 2006, at 7:21 PM, Qingqing Zhou wrote:
On Wed, 11 Jan 2006, Ari Kahn wrote:
Mac OSX 10.4
Seems this is a known problem of Mac. Try to google "vm_allocate
f
Mac OSX 10.4
On Jan 11, 2006, at 7:09 PM, Qingqing Zhou wrote:
On Wed, 11 Jan 2006, Ari Kahn wrote:
I have LOTS of memory (5GB).
What is the appropriate way to add more memory slots?
Or increase my VM file size?
Hmm ... What OS are you using?
Regards,
Qingqing
"Ari Kahn" wrote
> I'm doing a query that really should be too taxing. But when I
execute it
> I get the following error(s):
>
> psql(18967) malloc: *** vm_allocate(size=8421376) failed (error
code=3)
>
> Nested Loop (cost=89.36..6086.42 rows=2733
I'm doing a query that really should be too taxing. But when I
execute it I get the following error(s):
psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)
psql(18967) malloc: *** error: can't allocate region
psql(18967) malloc: *** set a breakpoint in szone_error to debug
10 matches
Mail list logo
