Hi...
Is there any equivalent sql
commands/queries for
' \l ' (which list out
all the databases) and
' \dt ' ( Which lists all the
Tables of the current database)
If anybody knows Please tell me.Or If there is any
way to get the info of databases and tables pls..Explain me
This is ve
psql -E
To see what that does :
man psql
sandhya mentioned :
=> Hi...
=> Is there any equivalent sql commands/queries for
=> ' \l ' (which list out all the databases) and
=> ' \dt ' ( Which lists all the Tables of the current database)
=> If anybody knows Please tell me.Or If there is any
No...What i need is...
I want to know the equivalent sql queries for \l and \dt commands in order
to list the databases and tables.
I want to do it through programming
Thanks
Sandhya
- Original Message -
From: "Stef" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "postgre" ;
Start psql with -E option to see the statements used internally.
On 22.09.2005 11:47, sandhya wrote:
Is there any equivalent sql commands/queries for
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriat
Thank you..Hannes
- Original Message -
From: "Hannes Dorbath" <[EMAIL PROTECTED]>
To:
Sent: Thursday, September 22, 2005 3:48 PM
Subject: Re: [ADMIN] Reg: sql commands
> Start psql with -E option to see the statements used internally.
>
> On 22.09.2005 11:47, sandhya wrote:
> >
sandhya mentioned :
=> No...What i need is...
=> I want to know the equivalent sql queries for \l and \dt commands in order
=> to list the databases and tables.
=> I want to do it through programming
From the psql man-page :
-E
--echo-hidden
Echoes the actual queries generated by \d and
Hi ,
I suppose pgdump_all creates a SQL script
that is capable of recreating the entire database
except for large_objects.
However pgdump_all produces one single large
SQL files and is not useful(easy) if one has to restore
a particular table.
For this reason we backup our databases individuall
I am having some problems with the COPY... to FILE command - and I am
wondering if anyone has experienced similar problems in the past, and what
you may have done to resolve the problem?
The platform is Free BSD, Postgres version 7.4.5 and the program triggering
the COPY command is a CGI scrip
On Thu, Sep 22, 2005 at 08:27:00AM -0500, Kevin Keith wrote:
> The platform is Free BSD, Postgres version 7.4.5 and the program triggering
> the COPY command is a CGI script.
What language and API are you using? In the next paragraph you
mention PQexec(), which implies C or C++ and libpq (some p
On 16.09.2005 07:31, Victor Sudakov wrote:
Is there any way to fix or workaround this except editing the dump with a text
editor (very frustrating with dozens of objects in several schemas being out of
order)?
In case you only have a text dump.. uhm.. No.
In case it's a binary dump, using a n
On 22.09.2005 14:26, Rajesh Kumar Mallah wrote:
My doubt is are the individual database backup files
created through -Fc options along with an SQL file
created using "pgdump_all -g " sufficient to recreate
the entire database ?
It always was sufficient for us in the past, we're doing exactly t
It is a CGI (shell) script that is calling a C program. I found the issue -
which was external to Postgres.
I still have one remaining question - if the COPY to FILE command fails,
does it return an error? If the program uses:
int i;
i = PQexec("copy from <> to <>");
and the table has (for ex
Title: Message
Is there a way to
skip errors during the run of the COPY command (loading data from a file to a
table) like what Oracle SQL*Loader has? The reason I'm asking is that
if the extract file from the mainframe has an invalid character, the COPY
terminates and doesn't continue lo
I'm having problem backing up several tables using pg_dump. When
selecting one table only with the '-t' option, it works just fine. When
I tried to include several tables, pg_dump fails with error that the
tables specified don't exist. Can you show me an example of backing up
several tables using
man pg_dump seems to say it is not possible
-t table
--table=table
Dump data for table only. It is possible for there to be multi-
ple tables with the same name in different schemas; if that is
the case, all matching tables will be
Tomeh, Husam wrote:
>
> Is there a way to skip errors during the run of the COPY command
> (loading data from a file to a table) like what Oracle SQL*Loader has?
> The reason I'm asking is that if the extract file from the mainframe has
> an invalid character, the COPY terminates and doesn't cont
On Thu, Sep 22, 2005 at 04:41:57PM -0400, Bruce Momjian wrote:
> Tomeh, Husam wrote:
> >
> > Is there a way to skip errors during the run of the COPY command
> > (loading data from a file to a table) like what Oracle SQL*Loader has?
> > The reason I'm asking is that if the extract file from the m
On 22.09.2005 21:38, Tomeh, Husam wrote:
Can you show me an example of backing up several tables using pg_dump.
I'd just warp pg_dump in a little (shell-)script or dump all tables and
pass pg_restore a TOC list (-L option) of objects I want.
--
Regards,
Hannes Dorbath
-
Folks,
A client is asking us about data security, and keeping data encrypted on
disk. I recall there was some discussion about this before, including
things like for it to be secure an operator would need to put in a key when
the disk is mounted, that once it is mounted anyone with permis
Ls,
any user can change his own password,
i haven't found a way of prohibiting this.
what about a general user (eg test/test), that is used by many people,
one of those people could use alter user (being connected as test/test) the
change the password, leaving the rest clueless..
suggestions to
Title: RE: [ADMIN] alter user
Instead of using a general purpose account, why not give everyone an account, then make them a member of a group, and give that group the access.
That way you can easily add / remove people from the group instead of trying to do it this way.
Otherwise, don't us
On Thu, Sep 22, 2005 at 11:49:24AM -0500, Kevin Keith wrote:
> It is a CGI (shell) script that is calling a C program. I found the issue -
> which was external to Postgres.
So what was it? Even if it wasn't a PostgreSQL problem it might
be educational to learn what happened.
> I still have one
On Friday 23 September 2005 01:51, Scott Marlowe seinde rooksignalen:
> Instead of using a general purpose account, why not give everyone an
> account, then make them a member of a group, and give that group the
> access.
>
> That way you can easily add / remove people from the group instead of
> t
Title: PgAdmin3 1.2.2 Install on Win32 Disrupts Pg Service
System: Windows XP Pro SP2
Running Postgres 8.0.3 for several months with the embedded PgAdmin3 1.2.1 on the same machine with no problems. Postgres is configured to start automatically as a service. I installed the PgAdmin3 1.2.2 wh
Alvaro Herrera wrote:
> On Wed, Sep 07, 2005 at 12:38:44AM -0500, Jim C. Nasby wrote:
> > On Tue, Sep 06, 2005 at 08:22:34PM -0400, Tom Lane wrote:
> > > PG 8.1 will have a function to return postmaster start time, but not
> > > database reset time. I wonder if this is misdefined --- if you are
>
On Fri, Sep 23, 2005 at 01:13:37 +0200,
Wim Bertels <[EMAIL PROTECTED]> wrote:
> Ls,
>
> any user can change his own password,
> i haven't found a way of prohibiting this.
> what about a general user (eg test/test), that is used by many people,
> one of those people could use alter user (being c
On Fri, Sep 23, 2005 at 02:32:51 +0200,
Wim Bertels <[EMAIL PROTECTED]> wrote:
> >
> > Otherwise, don't use a password, set the machine to use trust or ident or
> > something like that where a password wouldn't matter.
>
> although it is then a user/pasword known by a lot of people,
> it is stil
Hi ,
I suppose pgdump_all creates a SQL script
that is capable of recreating the entire database
except for large_objects.
However pgdump_all produces one single large
SQL files and is not useful(easy) if one has to restore
a particular table.
For this reason we backup our databases individua
Hi:
I did a vacuum verbose on my database and at the end of the output I got
the following:
INFO: free space map: 85 relations, 18940 pages stored; 29584 total pages
needed
DETAIL: Allocated FSM size: 1000 relations + 2 pages = 186 kB shared
memory.
VACUUM
Can somebody tell me wh
Robert Ngo wrote:
Robert Ngo wrote:
Chris Browne wrote:
[EMAIL PROTECTED] (Robert Ngo) writes:
Can i create create a cluster of postgresql server by sharing the
database file on a SAN? I am also looking into slony but slony
replicate
data to each server and my database will potentially
Hi,
Can i create create a cluster of postgresql server by sharing the
database file on a SAN? I am also looking into slony but slony replicate
data to each server and my database will potentially have terabytes of
data. I am thinking about a solution where a cluster of database server
will sh
Platform: Windows XP/Cygwin
PostgreSQL version: 7.4
PgAdmin version: 1.3.0 (Sep 15 2005)
Problems/Suggestions:
1. pgAdmin hangs when I view the details of a newly created job (without creating a step or a schedule yet)
2. When I do create a job, a step and a schedule at the same time, I get:
ER
I am trying to
moving data from a DB2 database, but some rows has ^M in it.
I
am changing the ^M to \r\n, but the \r\n is invoked in the string
instead of being functional.
The fields are separated with | and quotes with
"
This since there
could be , in the data, and I'm using
copy
HI All:
I have built a runtime environment of Mingw that
including the newest version of autoconf,
automake,libtool , libiconv and gettext that have been
tested, if you don't have full
runtime environment of Mingw , you can donwload it
from :
http://sourceforge.net/project/showfiles.php?group_id=
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Warren Snelling wrote:
>
>
> Would you suggest scripting the vacuum full / reindex process to
> run periodically (once a week or so)? Right now disk space on this
> machine is not an issue, but vacuuming and reindexing occasionally
> should keep the d
I'm using PostgreSQL 7.3.6 and run into a permissions problem when a
particular constraint trigger is attempting to restore using
pg_restore.
Is there a good way to analyze what permissions are required for a
particular constraint trigger? I have a problem where it looks like a
contraint trigger
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Why do you say that? Ident authentication is secure if you are on the same
> box as the postgers server.
The real question is this: given that you don't believe in a personal
password as authorization to use the database, what exactly *would* you
like
You need to increase your max_fsm_pages to at least 29584 pages to
accommodate / monitor all free pages.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Colton A Smith
Sent: Thursday, 22 September 2005 8:00 a.m.
To: pgsql-admin@postgresql.org
Subject: [ADMIN]
38 matches
Mail list logo
