And the \d+ on users? Also would you mind pasting the output exactly as it
is appears on screen, assuming it is in English?
I'm trying to build up a picture here of how many problems you have and
whether they can be fixed conventionally with the database interface or
whether you need to start
You can describe an object with the psql command \d. \d+ gives you extended
information. So at the psql command line if you type the following -
\d+ users
You should see a description of the layout of the table along with
associated indexes.
On Mon, Nov 22, 2010 at 8:56 AM, Lukasz Brodziak
I might be being optimistic but I should be able to make sense of the \d+
output if you can post that.
On Mon, Nov 22, 2010 at 10:04 AM, Lukasz Brodziak lukasz.brodz...@gmail.com
wrote:
The output is in Polish :) is there anything particular to look for?
Depends on your OS. Are you using Linux or Windows?
If you're using a linux terminal window you can usually highlight it and
ctrl-shift-c. Or use the menus.
On Mon, Nov 22, 2010 at 10:15 AM, Lukasz Brodziak lukasz.brodz...@gmail.com
wrote:
Lame question - how to copy output from psql
A few more information requests if you don't mind.
Can you analyze the table ie ANALYZE USERS without error?
Could you please paste the output from \d+ users.
And try SELECT COUNT(*) FROM users WHERE id_usr IS NULL;
Is your database large? Can you shut down the instance cleanly and take a
Can you post the select and the exact error?
On Sun, Nov 21, 2010 at 6:43 PM, Lukasz Brodziak
lukasz.brodz...@gmail.comwrote:
Hello,
I have a problem with one of the tables in my database. The thing is
that one of the rows is present in corresponding data file yet I'm
unable to perform any
Oh and could we please have the output from SELECT version(); too please.
On Sun, Nov 21, 2010 at 7:56 PM, Matthew Walden matthew.wal...@bcs.orgwrote:
A few more information requests if you don't mind.
Can you analyze the table ie ANALYZE USERS without error?
Could you please paste