What's the equivalent to show tables (from MySQL) in PostgreSQL?

What is the best way to get the names of all of the tables in a specific database on SQL Server?

I have a table: table votes ( id, user, email, address, primary key(id), ); How can I make the columns user, email, address unique - i.e., ensure that there isn't any pair of rows ...

I want to migrate my iPhone app to a new database version. Since I don't have some version saved, I need to check if certain column names exist. This Stackoverflow entry suggests doing the select ...

I'm looking for a way to find the row count for all my tables in PostgreSQL. I know I can do this one table at a time with SELECT COUNT(*) FROM table_name; …but I'd like to see the row count for all ...

I am looking for the syntax for dumping all data in my mysql database. I don't want any table information.

I want to create a table in a SQLite database only if doesn't exist already. Is there any way to do this? I don't want to drop the table if it exists, only create it if it doesn't.

I have a database called foo and a database called bar. I have a table in foo called tblFoobar that I want to move (data and all) to database bar from database foo. What is the SQL statement to do ...

In a MySQL script you can write: CREATE TABLE IF NOT EXISTS foo ...; ... other stuff ... and then you can run the script many times without re-creating the table. How do you do this in PostgreSQL?

If I want to save any changes in a table, previously saved in SQL Server Management Studio (no data in table present) I get an error message: Saving changes is not permitted. The changes you have ...

I know the statement: create table xyz_new as select * from xyz; Which copies the structure and the data, but what if I just want the structure?

I changed the datadir of a MySQL installation and all the bases moved correctly except for one. I can connect and USE the database. SHOW TABLES also returns me all the tables correctly, and the files ...

This is probably a n00blike (or worse) question. But I've always viewed a schema as a table definition in a database. This is wrong or not entirely correct. I don't remember much from my database ...

I regularly need to delete all the data from my PostgreSQL database before a rebuild. How would I do this directly in SQL? At the moment I've managed to come up with a SQL statement that returns all ...

How do I dump the data, and only the data, not the schema, of some SQLite3 tables of a database (not all the tables)? The dump should be in SQL format, as it should be easily re-entered into the ...