5
Postgres query to list all table names
source link: https://www.codesd.com/item/postgres-query-to-list-all-table-names.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Postgres query to list all table names
advertisements
Is there any query available to list all tables in my Postgres DB.
I tried out one query like:
SELECT table_name FROM information_schema.tables
WHERE table_schema='public'
But this query returns views also.
How can i get only table names only, not views?
What bout this query (based on the description from manual)?
SELECT table_name
FROM information_schema.tables
WHERE table_schema='public'
AND table_type='BASE TABLE';
Related Articles
How can I list all table names in SQL Server using T-SQL?
SELECT name FROM sys.databases -- this can list all database name in the server user database SELECT * FROM INFORMATION_SCHEMA.TABLES -- these two line can list the table for one particular database But how can I output the results like below? Databa
Query to select all table names that do not have their names in uppercase
Can anyone provide me a query to select the list of all tables in a db that doesn't have their names in uppercase?@gbn's answer is correct for any up to date version of SQL Server. For 2000: SELECT * FROM sysobjects WHERE UPPER(name) COLLATE Latin1_G
List all tables in Hibernate
I want to list all table names from database. My application has to be independent from DBMS. Different DBMS has different command to list tables, e.g: PstgreSQL: SELECT * FROM pg_catalog.pg_tables MySQL: show tables Oracle: SELECT DISTINCT OBJECT_NA
List of table names
I'm in the process of trying to migrate my ASPNET site to Django. All my current data is tied up in MS SQL Server on a shared host that (helpfully) doesn't support python... I could use my existing code to export all the data but I've also stopped us
Fill in a list with all table names that have columns specified via sql in c #
I have a database in sql server which is having few tables in it. I need to populate a listbox which contains a list of tables names from the database which contains a specified column name say 'special' . i have tried something like.. using (SqlConn
Lists ALL library names in SAS libraries
I would like to search a sas data sets with name include "Loan". If i know the specific library i can do it by proc datasets proc datasets library = work memtype = data; contents data = _all_ (keep = libname memname name) out = work.table_name;
How can I list all tables in a schema in Oracle SQL?
How do i list all tables in a schema in Oracle SQL?To see all tables in another schema, you need to have one or more of the following system privileges: SELECT ANY DICTIONARY (SELECT | INSERT | UPDATE | DELETE) ANY TABLE or the big-hammer, the DBA ro
List all tables in DB
I am trying to show a list of all tables within my database I have the below code: $result=mysql_query("SELECT TABLE_NAME FROM vogaldes_fuse.INFORMATION_SCHEMA.Tables ")or die('ERROR 315' ); $num_rows = mysql_num_rows($result); echo "$num_r
sql query to retrieve all tables in an updated schema on sysdate
This question already has an answer here: How to find out when an Oracle table was updated the last time 10 answers need to write a sql query to fetch all tables in a schema that was updated on sysdate. select distinct(table_name) from All_Tab_Column
Get all table names in yii
How to get all table names in yii? The sql query in mySQL is SHOW TABLES. I tried: $sql = 'SHOW TABLES'; $tables = Yii::app()->db ->createCommand($sql) ->queryAll(); print_r($tables); It throws an error: CDbCommand failed to execute the SQL state
How do I get a list of table names that have a particular value in the column?
We got a requirement in our application like this. To develop a powershell script to update computername in web.config file and in database tables. This script will be executed if application was already installed but user has to change the computer
How to get the list of table names from a MySQL database in a C #?
How to obtain list of tables names from a MySQL database in a C#?see this link, its explain from the beginning of connect http://www.geekpedia.com/tutorial139_Connecting-to-MySQL-with-Csharp-and-ODBC.html u need to run "show tables" private void
Get all table names set up in SessionFactory
Is there a way to retrieve the name of all tables that are managed by the SessionFactory? For instance, all the tables that were added via AnnotationConfiguration.addAnnotatedClass(...))?Here is howto getting one tableName with getClassMetadata Class
How to list all class names in the current package with Java?
In my Java project I need to list all class names in the current package, I usually run my app in two different modes : <1> From NetBeans, <2> From an executable jar file packaged by the NetBeans. My question is : How to write my program so th
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK