Postgres 9.2 under FreeBSD 8.4 - How do I find the databases & tables? I'm trying to create an osm tileserver and am at the point where i've created the database to hold the output of osm2pgsql.  But I can find neither the database (map_data) nor, of course, its tables.  I need to softlink (ln -s) the tables to at least one other spindle, which has nearly a full TB of space open.  I look in pgsql/data/base and see a lot of subtrees with numeric names.  Presumably one of them is my map_data, but I can't find a name:number mapping table.

I'm used to MariaDB/MySQL, which seems much more straightforward to me.
Don't mess with the data files in the filesystem it's a sure way to get your database corrupted.

You can achieve what you want, by creating a tablespace and then move the table to the new tablespace:

create tablespace big_one LOCATION '/path/to/other/spindle';
alter table map_data set tablespace big_one;
commit;



Btw: MySQL isn't "more straightforward" - it's just different. And I could list several things that are much more "straightforward" in Postgres than in MySQL