[postgis-users] Why can I see my attribute data in Udig and not using SQL-commands ?

[Michael Fuhr]

On Tue, May 23, 2006 at 07:54:34AM -0700, Paul Ramsey wrote:
> Because the geometries are very large, so when psql tries to print  
> them to the screen, it creates a lot of white space first.  Try  
> "select count(*) from mytable".  If it is > 0 then you do have data.

You could also use psql's \x command to display columns vertically
instead of horizontally.  Example:

test=> SELECT * FROM foo;
 id |  name  |                    geom                    
----+--------+--------------------------------------------
  1 | Name 1 | 0101000000000000000000F03F000000000000F03F
  2 | Name 2 | 010100000000000000000000400000000000000040
  3 | Name 3 | 010100000000000000000008400000000000000840
(3 rows)

test=> \x
Expanded display is on.
test=> SELECT * FROM foo;
-[ RECORD 1 ]------------------------------------
id   | 1
name | Name 1
geom | 0101000000000000000000F03F000000000000F03F
-[ RECORD 2 ]------------------------------------
id   | 2
name | Name 2
geom | 010100000000000000000000400000000000000040
-[ RECORD 3 ]------------------------------------
id   | 3
name | Name 3
geom | 010100000000000000000008400000000000000840

-- 
Michael Fuhr