Search
 
SCRIPT & CODE EXAMPLE
 

SQL

psql show columns of table

SELECT 
   table_name, 
   column_name, 
   data_type 
FROM 
   information_schema.columns
WHERE 
   table_name = 'city';Code language: SQL (Structured Query Language) (sql)
Comment

view columns in table postgresql

d table_name
Comment

PREVIOUS NEXT
Code Example
Sql :: how to change mysql root password in windows 10 
Sql :: mysql add fields 
Sql :: calculate age in sql 
Sql :: postgresql substring 
Sql :: mysql jdbc timezone 
Sql :: wordpress print query sql 
Sql :: mysql sort by date column 
Sql :: oracle undo usage by session 
Sql :: job for postgresql.service failed because the control process exited with error code. see "systemctl status postgresql.service" and "journalctl -xe" for details. 
Sql :: psql connect 
Sql :: sql timestamp to date 
Sql :: oracle tables with column name 
Sql :: sql check if date is between 2 dates 
Sql :: mssql find deadlocks 
Sql :: select table column name in sql 
Sql :: flask sqlalchemy default value 
Sql :: sqlite3 show columns name 
Sql :: restore postgres database from dump 
Sql :: mysql select where starts with 
Sql :: install postgresql centos 5 
Sql :: mysql url 
Sql :: execute stored procedure 
Sql :: Alter table add column in SQL Server- NAYCode.com 
Sql :: copy table postgres 
Sql :: identify number of rows in sql 
Sql :: check constraint in sql 
Sql :: mysql delete all except 
Sql :: date format in postgresql 
Sql :: mysql clear screen 
Sql :: sql blank vs null 
ADD CONTENT
Topic
Content
Source link
Name
3+4 =