I'm trying to help the XRMS developers add postgres support ('cause that's
what I use). They've done well so far with help from other postgres users,
but now I've been asked to help getting the indices correct.
When installing the application I specified the database name as 'contacts'
(not
use pg_dump --schema-only
-- Original Message ---
From: Rich Shepard [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Sat, 28 Jan 2006 10:14:05 -0800 (PST)
Subject: [GENERAL] Viewing Database Scheme
I'm trying to help the XRMS developers add postgres support ('cause
Can you use redirection.
On 1/28/06, Rich Shepard [EMAIL PROTECTED] wrote:
I'm trying to help the XRMS developers add postgres support ('cause that's
what I use). They've done well so far with help from other postgres users,
but now I've been asked to help getting the indices correct.
Rich Shepard [EMAIL PROTECTED] writes:
When installing the application I specified the database name as 'contacts'
(not very innovative or clever, but descriptive). When I open the database
with 'psql contacts' and ask to have the tables dumped (with \d), they go
streaming by on the
Rich Shepard [EMAIL PROTECTED] writes:
When I open the database
with 'psql contacts' and ask to have the tables dumped (with \d), they go
streaming by on the display. Of course, the bash 'tee' or 'less' commands
don't work to allow me to capture the stream to a file or page through the
On Sat, 28 Jan 2006, Tom Lane wrote:
Not sure why you say of course there. \d output is properly paginated
for me, and I believe for most people. What platform are you on, and
what do you have environment variable PAGER set to? Is the output of
plain old SELECT commands paginated for you?
On Sat, 28 Jan 2006, Doug McNaught wrote:
You can either use 'pg_dump --schema-only' as another poster
suggested, or use the '\o' command in psql.
When I try 'pg_dump --schema-only' I get a continuation prompt, even with a
semicolon at the end of the command line. A second semicolon
On Sat, 28 Jan 2006, Ezra Taylor wrote:
Can you use redirection.
No. I get an error message.
contacts=# \dt xrms.tables
No matching relations found.
\dt: extra argument xrms.tables ignored
Rich
--
Richard B. Shepard, Ph.D. | Author of Quantifying Environmental
Applied
On Jan 28, 2006, at 3:20 PM, Rich Shepard wrote:
contacts=# \d | less
\d: extra argument less ignored
You can't do this via the psql prompt. A simple \d will output to
the screen, automatically using your $PAGER if the output is too long
to fit on your screen.
I can, however, run
On Sat, 28 Jan 2006, Eric B. Ridge wrote:
You can't do this via the psql prompt. A simple \d will output to the
screen, automatically using your $PAGER if the output is too long to fit on
your screen.
Eric,
That's what I assumed; perhaps I misunderstood Tom Lane's what do you mean
On Jan 28, 2006, at 4:12 PM, Rich Shepard wrote:
Please keep replies on the mailing list.
snip
Again, you can't use redirection via the psql prompt. But you can
do it
via your shell command line:
$ psql -c \dt xrms.tables
Well, that doesn't seem to be working here, either:
[EMAIL
On Jan 28, 2006, at 4:20 PM, Eric B. Ridge wrote:
Dude, pg_dump is not a psql command, nor is it a SQL command.
It's a command-line program. You run it from your shell:
$ pg_dump --schema-only pg_dump xrms-schema.dmp
pardon my type-o. This should read:
$ pg_dump --schema-only contacts
Rich Shepard [EMAIL PROTECTED] writes:
On Sat, 28 Jan 2006, Eric B. Ridge wrote:
Again, you can't use redirection via the psql prompt. But you can do it
via your shell command line:
$ psql -c \dt xrms.tables
Well, that doesn't seem to be working here, either:
[EMAIL PROTECTED] ~]$
Rich Shepard wrote:
I'm trying to help the XRMS developers add postgres support ('cause
that's
what I use). They've done well so far with help from other postgres users,
but now I've been asked to help getting the indices correct.
Hi Rich. Seems once again we're meeting in the same places.
On Sat, 28 Jan 2006, Eric B. Ridge wrote:
That's because you've used the wrong syntax.
$ psql contacts -c \dt xrms.tables
This is why I suggested you read the psql man page.
Well, the man page installed shows the -c option is to specify one command,
but when I try that:
[EMAIL
On Sat, 28 Jan 2006, Roderick A. Anderson wrote:
Hi Rich. Seems once again we're meeting in the same places. The Internet
sure seems small sometimes.
Hello, again, Rod.
I saw all the other posts but you might look at dbwrench (a Java
application). Does a lot more than what you need
16 matches
Mail list logo